How to check if comma is present and replace it's occurrence

[RP1629548713]

Hi ,

I want to replace the comma which is coming in my days with empty

Example : Jenny may,Howard. Now i want this comma to get replaced by empty and the value to be passed ahead should be Jenny may Howard.

How can I achieve this in tmap.

Please suggest it's urgent​

[gjeremy1617088143]

Hi you can use (your String).replaceAll(","," "), you have to check before that your string is not null

eg :

!Relational.ISNULL(your String)?(your String).replaceAll(","," "):null

or

!Relational.ISNULL(your String)?(your String).replaceAll(","," "):(your default string value between doble quote)

Send me love and kudos

[Mr_B]

Hello,

gjeremy is right.

In a tMap you can use the dedicated function: StringHandling.EREPLACE("your_string",",","").

Hope this helps you.