Decimal separator change from dot to comma?

[Diego Vasquez]

Hello,

My name is Diego Vásquez and I hope you're healthy and safe.

I'm working on a project with Unilogic 1.32.98 with a PLC USP-070-B10 with CPU USC-P-B10.

I need to change decimal separator from dot to comma into the PLC because I'm exporting data into a .csv file and the decimal separator is generating problems when I open it into excel because It takes decimals as thousands.

Changing system separator from comma to dot solves the problem but it is not viable because my client is not willing to do it and that's why I need to change it into the PLC.

Thanks in advance.

Diego Vásquez C.

Edited May 27, 2022 by Diego Vasquez
Redaction

[Rivka]

Hello,

Can you please specify from which functionality within UniLogic you are exporting data into csv file?

 

[papouchka]

Hello,
I am re-launching this topic because I have the same problem.
I save at regular intervals a data table into a csv file with the ladder function : store DTI to File. I use the parameter F to 1.
When I export the csv file to import it in Excel, I have to manually replace all the dots by commas to use the results in excel formulas.

Is there a way to configure the decimal separator to indicate the comma and not the dot ?

Translated with www.DeepL.com/Translator (free version)

[Flex727]

5 minutes ago, papouchka said:

I have to manually replace all the dots by commas to use the results in excel formulas.

It looks like Excel will do this for you:

https://www.extendoffice.com/documents/excel/5229-excel-comma-to-decimal-point.html

[papouchka]

Thanks for the info but I'm already in decimal separator with the comma in excel. This works fine for data entry but not for a csv import into excel.
The automate saves the reals with a point as separator which is always present when importing into Excel. I then do an automatic replacement of the dot by a comma, it doesn't take much time but it has to be done every time, which is annoying.
The objective is to know if we can configure this decimal separator directly in the automate so that the real numbers are recorded with the comma as decimal separator!?.... any idea?

[Ausman]

I don't use Unistream but wondering if you could split the initial numbers up so that you could then regenerate them in the form of a string.  The string construction could be tailored to what you need, and you then export that.

[papouchka]

It's an idea but it adds extra processing. On the principle it bothers me a little.
I have the impression that I can't do the configuration I want.
I have just tested the converter proposed by unitronics which allows to obtain an Excel compatible file from an udtf (Comma Separator) and it works. I will go with that for now.

Thanks for your help.

[Ausman]

17 minutes ago, papouchka said:

converter proposed by unitronics

Do you mean the one Flex suggested above?

[papouchka]

Not at all.
Flex proposes to configure Excel to take into account the decimal separator that you want.
I found Unistream Data Converters Suite on this link :
https://www.unitronicsplc.com/software-unilogic-for-programmable-controllers/
At the bottom of the page.