Format txt file

[LHX]

Hi,

I have a VI that saves a cluster of 2 1D array into a txt file.

However, all the data is written into 1 column, how do i modify my VI so that when the data reaches -0.061901, the next line (0.000000) should start at another column instead of continuing on the next line.

And also, how do i add a title to both columns?

[Yamaeda]

(Hmm, some crap stayed in the picture, you only need the path control and the Write to spreadsheet with Transpose.)

You were almost there. 🙂

/Y

[moderator1983 · Accepted solution]

1. You need to transpose the 2D array of data.

2. Also, changing the 'Delimiter' from 'End of Line' to 'Comma', will help you writing a CSV file, that can be opened in Excel.

3. Your can add the Header manually.