Replace dots with commas

[FranciscoQ]

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,

CE

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 !

[marcus_sommer]

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

- Marcus

[Gui_Approbato]

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

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