ni.com is currently undergoing scheduled maintenance.
Some services may be unavailable at this time. Please contact us for help or try again later.
LabVIEW
offline present data from text file
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)
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
Hi Gerrit,
you can do it like this:
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
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).
see attachment.
I took an XY-graph and set the x-axis to show "absolute time" (right-click on graph -> x-axis formatting).
