Separating the lines in "Store DTI to File" output file

[Shaun]

Hi All,
I'm storing data in a Data Table. Once a day I write the data to a file using the "Store DTI to File" instruction. It all works well and a file is created.
I'm then using Excel VBA to read the data in one line at a time. The issue I am having is that the CSV file has  comma "," separating the lines. 

How do I get the Unitronics software to install a line break after each row from the data table?

[NoamM]

Hi Shaun,
"Store DTI to File" G parameter is the CSV file delimiter, change it to whatever you like. 

[Shaun]

Hi Noam,
Just so that I understand correctly. When the above instruction writes to a file it will put a comma between the data in a row and whatever we put into G between different rows.
So if I was to put "\n" in G I would get a new line in my file for each row in the data table.
 

Cheers,
Shaun

[NoamM]

I did not tested it but yes, that string value in G will use as the CSV delimiter  

[Shaun]

Thanks mate I will try it next time i am on site

[Saragani]

I think that NoamM did not understand your question and your request, The Delimiter G is what used to separate columns, not rows.

Rows are separated with \n  (0x0a)

Each column has a comma after it, even the last one, so if you have 2 columns, the data will look like:

A,B,\n

C,D,\n

 

etc..

 

You can take the CSV file and open it with a HEX editor and see the \n at the end of each line.