I need to truncate a chain of character from one column and copy it to another column.
In column A, I have : Value1 _ Value2
Final result required : Value 1 in column A and Value 2 (without the separator '_' ) in column B
Both columns belong to the same table.
Could you help pls?