Export to CSV - putting DEVs in seperate COLUMNS

So that thread has the writing in two/three-step process, which is kinda an extra step or two.
He has us assigning data to variables and then concatenating those variables with commas into an "all" variable value.

From that thread:

And then writing just that "all" variable value to the output file:





More Efficient: You can skip the all variable assignments and just stick the data-grabbing expressions directly into the writing, like:


The key point is the commas: CSV stands for Comma Separated Values. When you import a CSV to Excel, those commas become columns.

So Erwin, your writing code will be like:

and the commas will separate the values into columns automatically.

There is a catch, PC-DMIS has a 62-character line limit so sometimes you do have to use variables to concatenate chunks of stuff together as the quotes, plus signs, and commas add up real quick - and having long dimension names just makes it worse.
I had to do one for some software that needed a single line of raw data for a big program. This meant that the code was writing the values of 12 variables to a single line output file - but each of those 12 was created by concatenating 20 variables together - each of which itself was created by concatenating between 5 and 15 dimensional results. It took me forever to code all that jazz and they used it twice.

So that thread has the writing in two/three-step process, which is kinda an extra step or two.
He has us assigning data to variables and then concatenating those variables with commas into an "all" variable value.

From that thread:

And then writing just that "all" variable value to the output file:





More Efficient: You can skip the all variable assignments and just stick the data-grabbing expressions directly into the writing, like:


The key point is the commas: CSV stands for Comma Separated Values. When you import a CSV to Excel, those commas become columns.

So Erwin, your writing code will be like:

and the commas will separate the values into columns automatically.

There is a catch, PC-DMIS has a 62-character line limit so sometimes you do have to use variables to concatenate chunks of stuff together as the quotes, plus signs, and commas add up real quick - and having long dimension names just makes it worse.
I had to do one for some software that needed a single line of raw data for a big program. This meant that the code was writing the values of 12 variables to a single line output file - but each of those 12 was created by concatenating 20 variables together - each of which itself was created by concatenating between 5 and 15 dimensional results. It took me forever to code all that jazz and they used it twice.