formatting a large number of strings....?

[David99999]

I'm recording a lot of data, the text file has over 100 columns. And the way I know how to format everything is way too tedious for this amount of columns.

For example, if I want to initially create the file with the column names, I do this:

After that, I'd have a VI in a loop that is continuously formatting all the values into a string and writing to the file

Easy enough. But when I've got 100+ columns this gets "messy". Very prone to errors, I can easily forget a format specifier, etc.

Is there a better way to do this? I mean, I feel like my manual way is insanity.

[GerdW]

Hi David,

what about ArrayToSpreadsheetString?

Generic suggestions:

• Whatever you do with lots of controls could be done with an array of controls.
• With an array you could use a FOR loop to autoindex the elements - or use a function which is made to handle arrays…

[crossrulz]

I was also going to suggest the Array To Spreadsheet String.  It allows you to choose the delimiter and the format for all items.

[David99999]

Thanks guys, I will give this a go