Six Stars

How to remove special characters in the string

Hi Folks,

 

I am new to Talend and need one help from you guys.

 

How to remove the special character in a string field?

 

Like for example I have the input like -> 988788-99999

 

How do I get the output like below,

98878899999

 

Regards,

Deepak

 

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: How to remove special characters in the string

Hi,

Using a tMap with the following expression you should get the expected result:

row1.inputField.replaceAll("\\D", "") 

This will replace each non-digit character by nothing.

Here is a link to regular expression tutorial http://www.vogella.com/tutorials/JavaRegularExpressions/article.html

 

Hope this helps.


TRF
4 REPLIES
Employee

Re: How to remove special characters in the string

Hello,

 

In DataPrep, there is a function called "Remove non alpha numeric characters".

 

 

Best regards,

 

Vincent

Six Stars

Re: How to remove special characters in the string

Hi Vincent,

 

I don't see anything as such in expression builder.

 

Would you please show me with screen shot?

 

workflow1.PNG

Employee

Re: How to remove special characters in the string

Hello Deepak1,

 

if you are using Talend Open Studio, you can use tReplace in your job. In advanced mode, you can provide a regular expression.

 

Once you have a regular expression, that matches your 'special characters', you can replace them with an empty string.

 

Here is the link to the tReplace help : https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/jh3P41SE4Or9NQ0J0Gkfsg

 

Best regards,

 

Vincenty

 

Forteen Stars TRF
Forteen Stars

Re: How to remove special characters in the string

Hi,

Using a tMap with the following expression you should get the expected result:

row1.inputField.replaceAll("\\D", "") 

This will replace each non-digit character by nothing.

Here is a link to regular expression tutorial http://www.vogella.com/tutorials/JavaRegularExpressions/article.html

 

Hope this helps.


TRF