write a routine to remove special characters

[sbxr]

Hi Team,

I have a row which contain data mix with some special characters.need a java code to filter them.

please help me for both string and integer data types

Thanks

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[sbxr]

i want to create a routine to check whether this row has special characters and remove them .

i know that i can do it by using:

ReplaceAll() 

but want a routine to check for row whose type is string or integer.

row1.data

nme(int)| plc(str)

1*2!@|" fff#@  "

want to remove all the special as well as spaces and empty string and append word

[Anonymous]

Hello,

Could you please let us know if this topic:https://community.talend.com/t5/Design-and-Development/Regex-Expression-in-tmap/m-p/39391 helps?

Best regards

Sabrina