Diego Vasquez Posted May 27, 2022 Report Share Posted May 27, 2022 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Rivka Posted June 2, 2022 Report Share Posted June 2, 2022 Hello, Can you please specify from which functionality within UniLogic you are exporting data into csv file? Quote Link to comment Share on other sites More sharing options...
papouchka Posted November 9, 2022 Report Share Posted November 9, 2022 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) Quote Link to comment Share on other sites More sharing options...
MVP 2023 Flex727 Posted November 9, 2022 MVP 2023 Report Share Posted November 9, 2022 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 Quote Link to comment Share on other sites More sharing options...
papouchka Posted November 9, 2022 Report Share Posted November 9, 2022 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? Quote Link to comment Share on other sites More sharing options...
MVP 2023 Ausman Posted November 9, 2022 MVP 2023 Report Share Posted November 9, 2022 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. Quote Link to comment Share on other sites More sharing options...
papouchka Posted November 9, 2022 Report Share Posted November 9, 2022 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. Quote Link to comment Share on other sites More sharing options...
MVP 2023 Ausman Posted November 9, 2022 MVP 2023 Report Share Posted November 9, 2022 17 minutes ago, papouchka said: converter proposed by unitronics Do you mean the one Flex suggested above? Quote Link to comment Share on other sites More sharing options...
papouchka Posted November 10, 2022 Report Share Posted November 10, 2022 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.