topic Re: spreadsheet string to array or Read Spreadsheetfile into Array in LabVIEW

spreadsheet string to array or Read Spreadsheetfile into Array

Y3G — Tue, 20 Jun 2006 14:51:37 GMT

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

Re: spreadsheet string to array or Read Spreadsheetfile into Array

Dennis_Knutson — Tue, 20 Jun 2006 15:03:38 GMT

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

Re: spreadsheet string to array or Read Spreadsheetfile into Array

Y3G — Wed, 21 Jun 2006 06:54:48 GMT

Hi,

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

Re: spreadsheet string to array or Read Spreadsheetfile into Array

Dennis_Knutson — Wed, 21 Jun 2006 13:12:12 GMT

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?

Re: spreadsheet string to array or Read Spreadsheetfile into Array

Y3G — Wed, 21 Jun 2006 14:05:41 GMT

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