[resolved] how to remove more than one + symbol using tmap in talend DI

[Anonymous]

Hi,
how to remove more than one "+" symbol using tmap in talend DI
example
L+G+F+P  -->correct
but I'm having
L++++G++F+P ---->wrong

Appearance of ("+") is dynamic.

Pls find me a solution to fix this issue.
Any Suggestions....Thanks in advance.....

Thanks
Varsha K

[Anonymous]

Hello,
In your tmap, try this expression :

row1.col1.trim().replace("+","")

[Anonymous]

Hi tdz,
Thanks for your reply
but  row1.col1.trim().replace("+","") replaces all "+" with "" -->LGFP
I need L+G+F+P   as output.


Thanks
Varsha K

[Anonymous · Accepted solution]

This will work.....

row1.column.replaceAll("(\\+)\\1+","$1")

It uses a regex to replace multiple "+" symbols with a single instance wherever it occurs in the String.

[Anonymous]

Thanks Rilhia Solutions...
It works....