Modifying the the output of write to file function??

[dogbert03]

The top section is the ouput from the Labview program using the
write to file function is there any way it can be
modified to....(see attachment)

[Michael_Munroe]

Writing a text file during data collection can only be performed by adding rows to the file, not columns.

However, there are 3 common alternatives. First, write the data directly to Excel using ActiveX. Second, keep all data in memory until the test is complete, then transpose the data before writing (dangerous). Third, write all data to text file row by row, and at the completion of the test, read back the data file, transpose it and write it back to another file.

Michael

[David Duffey]

Hmm... It looks even more complex than just transposing the array.

Is this the "write waveform to file", I don't know of a write to file function.

I also noticed a "0 45 -45", where did those come from?

I think what you want is possible, it just depends on the way you are writing data to the file, and when you are writing to the file.

[Michael_Munroe]

What you want is a pivot table in Excel. I was able to import your origonal data file into an Excel sheet. Then using the pivot table wizard, I put the first column into the pivot rows, the second column into the pivot data, and the third column into the pivot columns. I looks just like your output format.

Michael