String to array for anaylsis

[kim515]

Dear All,

I got some problems from my labview problem.
Firstly, there is a part of my program(attachment). It is designed to save sring data to a .txt or .xls file.

When it ran, it worked.
If i set the type of save file be .txt, it displayed that (attachment)

If I set the type of save file be .xls(Excel file), it displayed all the data only in the column A.(Attachment)
I could not use it for doing analysis.

Who can help me to solve this problem?

Secondly, If all the data are strings, how can convert them into array? I have tried many times but i still could not do that. who can give me some hints or examples?

Thank you.

KIM  

[Dennis_Knutson]

If you want to have Excel automatically open the file and place the data in columns, you should use a tab separator instead of 4 spaces.

Not sure where you want to get a string array. On the entire string, you can use the function Spreadsheet String to Array. This requires you to specify the correct terminator.

[kim515]

i can do it now!
Thank you very much!