how to replace ". " in a string?

[Ray0801]

So i have a String column A

Column A

98,00

10,000.98

I need to remove "," (comma)and "." (dot)from the values from the data.

For ","

(comma)

Ereplace is working as expected (StringHandling.EREPLACE(row1.A,","," ")

But For

"." (dot) (StringHandling.EREPLACE(row1.A,"."," ") is giving me null output for the above data.

[Anonymous · Accepted solution]

Hi

Try this expression:

(row1.A.replaceAll("\\.", "")).replaceAll(",", "")

Regards

Shong

[Ray0801]

Thanks @Shicong Hong​ ,it works