topic Re: How to check if comma is present and replace it's occurrence in Talend Studio

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

RP1629548713 — Fri, 15 Nov 2024 23:14:50 GMT

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 — Fri, 04 Feb 2022 09:18:08 GMT

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

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

Send me love and kudos

Mr_B — Sat, 05 Feb 2022 19:55:58 GMT

Hello,

gjeremy is right.

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

Hope this helps you.