offline present data from text file

[lente]

hi,

How can i present data from a text file with several columns separated using tab delimiter  into a graph or a chart. I like to have the date and time on the x-as.

thanks,

Gerrit

[GerdW]

Hi Gerrit,

you should note your LV version as there are some small changes in text file handling in LV8+ compared to earlier versions...

But the process is still the same:
- read in the text file as simple string
- strip the header lines (remarks...) and the row with all column names (search the string for "date", search the next CR/NL, split string)
- use the "spreadsheet string to array" function to vonvert the remaining string to a 2D array of strings
- take the first 2 columns and convert them to a timestamp: use "scan from string" with format "%d-%d-%d" for date and "%d:%d:%d" for time, wire the results to a "date time rec" cluster, convert the cluster with "Date/Time to seconds" to a timestamp
- convert the remaining 2D array to numbers ("Frac/Exp string to number")
- use a XY-graph to plot the data (see context help for how-to-do)

Message Edited by GerdW on 09-26-2007 10:08 AM

[lente]

using lv 8.2

[lente]

Gerdw,

I tried to build the program but i have problems to build the cluster. Can you show me how to do it?

Gerrit

[GerdW]

Hi Gerrit,

you can do it like this:

Create the cluster constant by right-click on input of "date/time to seconds" and "create -> constant" to get a proper one!

Message Edited by GerdW on 09-26-2007 01:14 PM

[lente]

Gerdw,

The time date cluster works fine although i have a problem to filter the correct time data from the string and the measured values. (the line end with cr/lf)

gerrit

[GerdW]

Hi Gerrit,

see attachment. It works for me and your given textfile...

[lente]

Gerdw,

Just one problem, how set i the time stamp on the x-axis.

Gerrit

[GerdW]

Hi Lente,

see attachment.

I took an XY-graph and set the x-axis to show "absolute time" (right-click on graph -> x-axis formatting).

[lente]

GerdW,

Do you have a better solution for the attachment?

Gerrit