Re-Displaying Data

[Cory_K]

Heres the most recent of my endevours....

I collected data, and wrote that data to a spreadsheet file (tab delimeted, .txt)

The data is written in the following format:

1) Column Headings

2) Many rows of data

3) A few rows of comments

I'm trying to come up with the easiest way to read these data files, and re-graph them, so I can print them out if necessary.

The problem I run into is the headings and comments appear as all 0's.

So instead of being disregarded, they are graphed as 0's.

Is there a way around this?

Also, when I am graphing these, how would format the graph so that it reads the first column of data as time?

[Cory_K]

Well, i figured out the latter of my 2 questions, but not the first.

Do you think I can put a "greater?" function in,
so that only the values greater than 0 will be graphed?

[GerdW]

Hi Cory,

read in the spreadsheet data as 2d array of strings. Then use array subset to get only the data part and now use any conversion function you like.
Or (even easier) use the array subset on your array after loading in to strip the rows with zeros in it...

[Cory_K]

The data reads as a "signal".

Can i convert a signal to a 2d array?

[GerdW]

Hi Cory,

why don't you just attach example code and example data? And which LV version do you use?

From your question I conclude you're using an Express vi to read you spreadsheet. I wouldn't go that way (my personal opinion)...
I prefer this:

Most of the time you also want to parse that extra lines and need to load the whole file anyway... Using my approach it's very easy to strip single rows from the spreadsheet to parse them differently.


Message Edited by GerdW on 08-07-2008 09:41 PM

[Cory_K]

OK, I see what you did.
Yeh, I think I will give that a try.