Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hello,
gjeremy is right.
In a tMap you can use the dedicated function: StringHandling.EREPLACE("your_string",",","").
Hope this helps you.