Getting labview to save data with a comma after the last column

[novastar15]

Hello,

I have labview outputing data made up of several columns of data and they are each seperated by a comma, but the program that I have needs there to be a comma at the end of the data in the last column and it seems simple enough.  Just not sure how to do that.

Thanks

Message Edited by novastar15 on 11-10-2005 12:32 PM

[tbob]

You say you are outputting data.  How?  To the screen, to a file?  Is your data in the form of an array (if so 1D or 2D)?  It is simple to append a comma.  If an array, you can simply use Insert Into Array and leave the index unwired.  The character will be put at the end of the array.

[ycw7]

Hi,

I hope that is you want~

由 ycw7 在 11-11-2005 02:56 AM 上編輯的訊息

[novastar15]

The data I am saving is a 2-D array of number, and I am saving them into a text file.  Right a row looks something like 123, 342, 12334, 23342  so what I need is a comma after the last entry in every row so that the program can read the files.  Becuase it wants.  123, 324, 12334, 23342,

Thanks

[tbob]

Unfortunately you can't use Write Spreadsheet to File because that puts an End of Line after each row.  Even Array to Spreadsheet String puts EOL after the line, so you can't simply append a comma.  You have to break down the array into each element, change to string, concatenate all elements with commas after each element, then add EOL after each row.  See attached vi on how to make the string.  Then write this string to a file.

[Dynamik]

Hi NovaStar15,

Would this work for you?

[DavidJCrawford]

Another approach to tbobs would be to

1. Use convert using Array to Spreadsheet String.

2. Replace all <CR><LF> with <,><CR><LF>. The string constants are viewed in '\' mode. \r is <CR> and \n is <LF>

3. Reverse the string and look for the last <LF><CR> using match pattern.

4. Extract the portion of the string after the match

5. Reverse it back and you should be left with a comma seperated list without the last <CR><LF> ready to write to file.

I have attached simple example in 7.1.

David

ps Dynamik your images were not there. It was only the the empy image place holders (box with red X)

[Dynamik]

Thanks David!  Yes, it looked just fine on my screen.

Well these just show piping the 2D array straight into the ArrayToSS String -

... but using the format string to put comma after every value...

[tbob]

Great solution Dynamik.  For that you get 5 stars.  I never thought about putting a comma in the format string.

[novastar15]

Thanks for the help guys, I will give those give those solutions a try today!

🙂