why are date and time strings lost when indexing an array in a for loop

[adavies78]

Hi, 

I have an application where i'm reformatting data from a spreadsheet for graphical display on a LabVIEW dashboard.

the original spreadsheet has date and time values in separate columns, and i'm merging them and converting to a timestamp value.  But something's not working.  Does anyone know why the string value is lost when the array indexes into this for loop?

[altenbach]

Can you attach your VI with some typical values? (e.g. create in indicator on the 2D array, run your VI, then turn the indicator (now containing data) into a diagram constant). Place the FOR loop related code and that diagram constant into a new VI and attach it here.

How many times does the FOR loop run? Could it be that the last element of each 1D array is an empty string? (unless you put a wait inside the FOR loop, you'll never see the other elements in the probe)

[nathand]

It looks like you're reading the values out of the string array properly (although it would be cleaner to use a single Index Array and extend it to get an additional output).  However, I don't think your format string matches the format of the text, which will cause Scan from String to fail.  It appears that you're going to have the date and time in the format "00:00:00 10/5/2012".  I can't tell if there's a space in your format string, but I can tell you that it appears you have an extra % character (at the end of the top line).  I'd break out just the Scan from String into a separate VI and make sure you have the format string correct.