Problem with creating .csv log in SD card with Vision V350-35-TU24

[vamalgise]

Hi all,

 

I am trying to create .csv file log in V350-35-TU24.

In Create Excel Delimited Line function I create 7 column in a line. As in example application SD card Demo I set the last column's delimiters as CR and LF to create a new row for a new 7 values. But I faced the problem that all 7 values were stored in 1 cell, not 7. Do I use wrong delimiters? What should I do to have 7 columns with 1 value in each of them, not 1 column with 7 values in it?

 

Hope for your support guys! Thank you!

 

[EduMarg]

Hi vamalgise,

 

The delimiter can change depending of your region.

Some places use as delimiter the coma "," some regions use the semicolon ";" .

What symbol are you using as delimiter?

Try changing it to the second option.

• if you use coma use semicolon instead
• If you use semicolon use coma instead

Another option to separate the columns is to go to excel and

1. Select the text you wish to divide in columns
2. go to the data menu, there you will see the icon  or option Text to column. select this option.
3. a new windows will pop up where you will have options delimiter or fix text. Select delimiter and click on next.
4. You will have  a list of delimiters: tab, coma, semicolon, etc. Select the one that adapts to you needs and click next two more times

 

This should solve your issue.

Regards

[vamalgise]

Thank you EduMarg for your advice,
I use comma as a delimiter. Now I opened the same file on another computer and it looks properly, like each value is stored in separate cell.

Unfortunately do not know how to attach files in this forum to demonstrate, but I guess you understand what I mean.

PS! Is it possible to assign each column with name? or it could be only done in excel?

Thanks!

[EduMarg]

Vamalgise,

 

I'm glad my advice helped you.

 

Attached an example on how to created titles on a CSV file using delimited line.

You will see that in this example, once a day or when a new file is created, the first thing it does is write titles into the first row.

 

Hope this helps.

Regards.

V570_sd_delimited_line.vlp

[vamalgise]

Thank you for the example.

There is one more issue need to be solved. I have 1 integer in my .csv file, 1 give it 1 sign after the coma (so the format is 00.0). When this value is placed in a cell, it shows me, for example, 22.april instead of 22.4, and when I format cells to change the data type it gives some random constant value for all the collumn values. Is there a way to use comma instead of dot to give a decimal point to integer to display it properly in .csv file?

Thank you for your support and help!

[EduMarg]

using coma is not possible, Even if converting the number to ascii and changing the point to a coma because you choose as delimiter coma.

This will separate the decimal part and the integer part of the number into two cells.

 

In the example I post you will notice that I write the value of pressure to the delimited line. This value is changed to ascii before writing it to the CSV file.

Are you also converting the integer to ASCII?

 

You can do it as in the example and on the E input of the NUM to ASCII block use a constant to determine the decimal point location.

so for example if your integer is 100 and you wish to see 10.0 use on this input a value of 1.

 

Hope this helps.

[vamalgise]

EduMarg, I do not convert my integer to ASCII, what is the point in that? I only place my integer in the SD Utility Delimited Line and assign the format inside the function.