conversion of data string to an array that i can use "write to spreadsheet file.vi"

[oliver_ziegler@web.de]

Hello,

I'm using "LabVIEW 7.1 Express" since 3 months. I've already programmed a lot of VI's. My biggest one is a test program for a several voltages. The program recognizes the state vs the voltage. So i get an xy - graph and two tables of data. At the end, the RT system, on which the program is running, sends the data per TCP/IP to the host PC. On the host PC i want to use "Write to Spreadsheet File.vi" to save the data as txt-file to disk. My problem is that the data i want to send is a 2-D array of strings. So i have to change the format into a simple 2-D/or 1D array! I've tried nearly everything to convert the data, but it's always the same, my txt-File contain either an array of "0" or some numbers, but never the right measurement data.

Can someone quickly help me?

Best regards

[mfitzsimons]

If there is no text in your output just convert the string array to a number array wand save it to file.

If there is text in your file then I would save it in text format.  You need to use file open, write, and close.

Let me know if this answered your question

[BiomedEE]

Here is an example that seems to work for me.

[BiomedEE]

Sorry I did see you were 7.1, here is a 7.1 version

[oliver_ziegler@web.de]

There is a text in my file, for the labelling of the table, otherwise an other user can't understand the measurement data!

For the TCP connection i already use "TCP open/write/read/close .vi' s" !

[oliver_ziegler@web.de]

Hello and thanks for this VI, it was very useful. The only problem I still  have, is that the labelling doesn't match, but the measurement data is complete in Excel! I'm looking forward to solve this problem! Perhaps you also have an idea for this!

Thanks a lot!