Skip to content

Splitting column into multiple columns

4 messages · ajay ohri, Henrique Dallazuanna

#
Hi All,

I have the following data in one column for each row , (each value is
like x1,y1,z1 space x2,y2,z2 space....)

77.56787,22.09909,0 73.26787,21.09909,0
76.53487,23.09909,0 75.56787,22.09909,0
76.54587,22.09909,0 76.56787,22.03509,0
75.56457,22.05609,0 76.56787,22.05609,0

Note all z values are O (hence ,0 can be treated as a delimiter)

How do I split this column into multiple columns for each row.

Regards,
Ajay

www.decisionstats.com
#
Hi Henrique ,

Thanks for this. An additional problem is that each row begins and ends with a "

So when i try and copy and paste (94 rows) , it does not work with the
last value within a row.

Each row has some 50 x1,y1,0 values.

How to modify the code for this?

Regards,

Ajay