Replace dots with commas

FranciscoQ — Fri, 10 Sep 2021 18:24:36 GMT

Hi !

I am developing an App using the data load editor (script)

The thing is I connected The app with a website and I am downloading some currency exchange information.

The thing is that the numbers are with a dot, and i need them with a coma, ex:

DATE ; CE

10/10/03 ; 12.345

12/10/04 ; 13.567

etc, etc

And I need :

12,345

13,567

etc etc

In the script I don't have the values, I have the fields:

Load

Date,

FROM....

So I need to work with the fields, and the replace function doesn't work.

Maybe with Num or Num# but I don't know how to make them work,

I would appreciate some help,

Thanks !

Re: Replace dots with commas

marcus_sommer — Sun, 12 Sep 2021 10:47:16 GMT

You could try it with: num(num#(CE, '#.#', '.', ','))

- Marcus

Gui_Approbato — Sun, 12 Sep 2021 14:56:03 GMT

Adding to Marcus' answer, an alterantive would be using:

replace( CE, '.' , ',' ) as CE