spread sheet from data

[Rob.Judd]

i am receiving data in the format 26.3,35.3,980.2,0.000,0.000,0.000,29/06/04,13:21:15 and i need to save it into a spreadsheet file where the columns are delineated by the commas. i can't figure out the right conversion of the raw data so it will fit in the write to spreadsheet fil.vi. please help. thanks!

[John Rich]

Since you have a set of comma delimited data you can use the "Write characters to file" instead of the "Write spreadsheet to file" function. This will give you a comma delimited text file which you can then import into your spreadsheet program. This is a much more versatile approach as you can use text, dates, etc. directly. The "Write to spreadsheet file" only writes single precision numeric data.

[Rob.Judd]

thanks you so much, i actually just tried that out about 2 minutes before your response and it worked. i really appreciate your help.