topic how to replace ". " in a string? in Talend Studio

how to replace ". " in a string?

Ray0801 — Wed, 11 Aug 2021 17:25:29 GMT

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 — Thu, 12 Aug 2021 04:11:19 GMT

Try this expression:

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

Regards

Shong

Ray0801 — Thu, 12 Aug 2021 06:38:08 GMT

Thanks @Shicong Hong ,it works