Jump to content
Sign in to follow this  
Shaun

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

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...