Displaying 1 result from an estimated 1 matches for "newlines2".
Did you mean:
newlines
2011 Jul 14
5
Splitting one column value into multiple rows
Hi i have the data in the following format:
rent,100,1,common,674
pipe,200,0,usual,864
car,300,1,uncommon,392:jump,700,0,common,664
car,200,1,uncommon,864:snap,900,1,usual,746
stint,600,1,uncommon,257
pull,800,0,usual,594
where as i want the above 6 lines data into 8 lines as below (Spliting row 3
& 4 at : and sending to a new row):
rent,100,1,common,674
pipe,200,0,usual,864