PPRuNe Forums - Extract Spreadsheet Data

PPRuNe Forums (https://www.pprune.org/)

- Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)

- - Extract Spreadsheet Data (https://www.pprune.org/computer-internet-issues-troubleshooting/540706-extract-spreadsheet-data.html)

gileraguy

29th May 2014 21:15

Extract Spreadsheet Data

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

29th May 2014 21:43

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

30th May 2014 22:45

thx m8

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

All times are GMT. The time now is 11:59.