Transpose a 1D string array

[MJ40]

Hi,

I am trying to create headers in a write to text file.  Attached is my code and what the file looks like when opened in Excel. I have my data in three columns, but the headers are not where I need them to be. LabVIEW doesn't seem to allow a transpose of a string array. Is there a way I can get the headers in a row format and not a column?

Thanks

[chilly_charly]

Add an additional "build array" after creating your 1D array of column headers. This will convert the array into a 2D array with a single row.

[johnsold]

Make a single string of your header strings. Put the same delimiter between them as you are using for the spreadsheet string.  You are now making an array with three elements and then appending the spreadsheet array string to that.

Lynn

[aeastet · Accepted solution]

Something like this.

[MJ40]

Adding a build array then creates an error between the final array and the write to text file saying I am feedin a 2D array of string into a 1d array of string sink.

And in response to the second post, I am not aware that I did any delimiting with the data. I transposed it and fed it into the write to text file. The delimiting was not explicitly set. Is there a way to delimit a concatenated string?

[tbob]

If you are going to use Write to Text File, you need to feed in a string, not an array.  This code will work:

As an alternative, you could use the Write to Spreadsheet File function instead of the Write to Text File.

[smercurio_fc]

---

@tbob wrote:

If you are going to use Write to Text File, you need to feed in a string, not an array. 

---

Not true.

[tbob]

OK I didn't know that.

[MJ40]

Thanks! I was able to fix the transpose problem.

However when my data is collected I have a strange offset. I tinkered with it and got some different excel output formats but not the one I want. Any ideas?

Code1 is the Code that gives the output to excel1.

Thanks.

[tbob]

Put a probe on your header array before it goes into the last build array.  Put a probe on your data also.  See what you have there.  Put probes on each input to the last build array, see what you have there.  Finally put a probe on the final array going into the File write.