04-25-2014 09:03 AM
Then stop using that one.
Use Spreadsheet string to Array with comma as the delimiter. Use a For Loop to iterate over each row of the 2-D array. Now inside that For Loop, you have a 1-D array that is one line, and each item is an element between the commas. Use Index Array to break apart that 1-D array into individual elements. Convert each item of that array to strings or numerics or whatever as needed.
04-25-2014 09:08 AM
Iv'e been using a template which altenbach posted, which is using a scan from string function. I thought this was the best option.
04-25-2014 09:28 AM
It probably was the best option the way your problem was first described. But now you have a different, more complicated data structure as Altenbach said in message #33. It may be possible to come up with a scan from string that will work. Or the best option now might be to approach the problem from a different angle.
04-25-2014 09:32 AM
I agree. you might just want to read it as a 2D array of strings using "read from spreadsheet file" then loop over each row, indexing out the relevant elements.
04-25-2014 01:48 PM - edited 04-25-2014 02:12 PM
Could you please post an example of this?
I tried finishing the scan from string version, the VI below is how far I got with it. I get 'error 1' when I try to run it.
Thanks