How to change format of price like 12,222.00 to 12222.00

[Former Member]

Hi ,

I have a requirement where i need to change the price format as 12,222.00 to 12222.00,ie i have to remove the ","

Regards,

Nowsheen.

[Former Member · Accepted solution]

Hi,

Use Replacestring Function which is available in Standard Functions(Text)

Mapp the source field to first input to Replacestring

Mapp the constant , to the second input of the Replacestring

Mapp the Constant (Dont give any thing, just empty) to the third input of the Replacestring

MApp the Replacestring to Target field

Regards

Seshagiri

[Former Member · Accepted solution]

Hi Sheshagiri,

Thanks alot , it solved my problem.

Thanks&Regards,

Nousheen.

[Former Member]

Hi Nowsheen,

You can change numeric field format by using "FormatNum" function on graphical mapping editor.

Best regards,

Orkun Gedik

[Former Member]

Hi

use UDF:

price = price.replaceAll(",","");
return price;

Regards Mario

[prateek]

2 options

1. Use FormatNum

2. U can use replaceString function and replace , with ""

Regards,

Prateek