06-12-2017 05:08 PM
Hello all,
I am trying to write a program that allows a user to open a file, skip the first 4 header lines, retrieve 3 columns of data (time, strain, and machine on/off), and analyze this data by calling a separate function.
My main issue is I don't know how to extract specific columns of data while also skipping the first lines of the text file.
Thank you so much for any help
Solved! Go to Solution.
06-12-2017 06:10 PM
EDIT: I no longer need to skip the header, but I am still struggling to extract the column data. I am using "Read Delimited Spreadsheet (Double)" with a delimiter of \t, but only one column is extracting.
Here is what I have (please excuse the quality, I am VERY new to LV)
06-12-2017 08:06 PM
You have wired up a string constant with a "space" character in it for the delimiter. Try deleting it so the default of a tab is used.
06-12-2017 11:20 PM
Hope the delimiter value should be provided as same as the column separation in the text file,
provide proper delimiter value and check, still if you are not able to debug attach the text file also for reference.
06-13-2017 03:24 PM
Thank you! I did not realize tab was the default.