Extract Spreadsheet Data

[gileraguy]

HI

I have an app that's downloaded data to email and the data is all in one column of the SS.


ie.

14:05:29,06:47:5.538,69.364414,70.129228

How can I easily extract the comma separated values in Open Office?

Matt

[Saab Dastard]

The easiest thing to do is to paste the data into a text file. Then save it with the extension .csv and open it with a spreadsheet program - it should prompt you as to how you want to deal with it, if it doesn't automatically detect the delineator. Excel 2010 auto-detected the sample you provided and parsed it into 4 columns from a file with a .csv extension.

SD

[gileraguy]

thx m8


file saved as csv and now I've got 4000 rows of data to try to chart!!!