decimal point

Business Central/NAV Developers Forum
1

Hi, one of my bigger problems in programming is, how can I use the format-command. I extract data from an ASCII-File and get 25.23 and have to convert it into 25,23. Another question: when I extract 2523, is there e possibility to convert this into 25,23? Thanks

2

Are you in a dataport, or reading directly through code with the READ function? On the dataport, you should put code in the OnBeforeImportRecord() trigger. Try to manage your numbers has text to do that kind of process and use something like this: MyNewStr := CONVERTSTR(‘25.23’, ‘.’, ‘,’);

3

Hi David, I read through the READ function.

4

Thanks, I have done it with CONVERTSTR: EVALUATE(SalesLine.“Unit Price”,CONVERTSTR(COPYSTR(SalesIn,4,18),’.’,’,’));