LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

sort data according to column headers

Hi,

I am having a problem trying to sort a 1D array of data into different columns in excel. Right now what I have is two arrays - one containing the name of the data and the other containing the data itself. I send the name to a case structure where the respective data is sorted and manipulated. The individual data is then written to the file through concatenate strings. The column headers in the file are already written in a previous file and the rest of the data is appended later.
My problem is that I just want to be able to read the header and put my data in that column accordingly without using concatenate strings. Is there a way to do this?
As I am dealing with CAN messages here so data needs to be sent in the corr
ect order. I can have timestamps appended to the data to form a cluster of name,data and timestamp.
I have attached a file to show how I am writing to file.

Please help.
Thanks
Shruti
0 Kudos
Message 1 of 2
(2,547 Views)
Array to Spreadsheet String (in the String functions palette) would allow you to avoid the concatenate strings. However, since you use different fractional width formats for different elements you might be better off staying with concatenate strings.

Lynn
0 Kudos
Message 2 of 2
(2,547 Views)