columns data split and rename column headers
Hi, I have Data_original.csv which have many columns of | or _ or none. In this example, I'm showing only 3 columns of |.I tried the data preview to see if I can split but my column got messed up. Data_original.csv...
Fruit,ID,Colors,Weigth,CountryCode
Apple,123456,5_2|1_4,3|3|3|oz,1_2_5|3_2_1_123_2343_342|1_2
Apricot,5555666,9_0|55_298,5|3|2|1|lb,0_9_1|23
Grape,98746,12_1|23_99,1|2|1|7|6|4|2|1|8|g,9_1_3