spreadsheet string to array or Read Spreadsheetfile into Array

[Y3G]

Hi,

I am using this attched txt-file (spreadsheet file) to read out the data to an array, but I get only the first column into the 2-D array. All the other columns are not read into it.

What do I wrong?

Thanks

[Dennis_Knutson]

What did you specify as the delimiter? Your columns are separated by spaces so that is what you should be using.

[Y3G]

Hi,

I used space (/s) as delimiter indication but it didn't work either.

[Dennis_Knutson]

I don't know what could be wrong. I used a \s and I was able to read all columns. You do realize that the data will not start until row 11 don't you?

[Y3G]

Yes Thanks,

I realized it myself after reading the HELP on the following String Control:

"Right-click a string control or indicator and select '\' Codes Display from the shortcut menu to instruct LabVIEW to interpret characters that immediately follow a backslash (\) as a code for non-displayable characters. The backslash mode is useful for debugging VIs and for sending non-displayable characters to instruments, serial ports, and other devices. The following list shows how LabVIEW interprets these codes."

Just after that it accepted my /s.

Thanks