topic Re: To remove unnecessary characters in string in Talend Studio

To remove unnecessary characters in string

Anonymous — Tue, 22 Jan 2013 08:20:35 GMT

Hi,
I just wonder how do I wants to removed certain character or word in string.
For example, there is string with data "good-morning". Then i wants to remove "-morning" and then the data will become as "good" only.
Plz help me

Regards,
Kal

Re: To remove unnecessary characters in string

Anonymous — Tue, 22 Jan 2013 08:46:59 GMT

Hi,
tFileInputPositionalComponent and tFileInputRegex component can meet your needs.
Best regards
Sabrina

Re: To remove unnecessary characters in string

janhess — Tue, 22 Jan 2013 09:20:10 GMT

Or in a tMap you could use column_name.replace("-morning","")

Re: To remove unnecessary characters in string

Anonymous — Wed, 23 Jan 2013 09:04:03 GMT

Hi, ae_kel29

I just wonder how do I wants to removed certain character or word in string.

If your requirement is just the example you set, the way @janhess provided is very good for you.
But if your real work have a lot of strings, it suggestion that use column_name.substring(int startIndex, int endIndex) in tMap.
Best regards
Sabrina

Re: To remove unnecessary characters in string

janhess — Wed, 23 Jan 2013 09:16:04 GMT

column_name.substring(int startIndex, int endIndex) in tMap.

This assumes the string to replace is in a fixed position.

Re: To remove unnecessary characters in string

Anonymous — Thu, 24 Jan 2013 03:22:13 GMT

Hi,
Yep, it depends on the replaced strings.
Best regards
Sabrina

Re: To remove unnecessary characters in string

_AnonymousUser — Mon, 20 Mar 2017 17:17:10 GMT

Hi There
How do i remove stranges caracteres li "" on tmap when passing a string??

Re: To remove unnecessary characters in string

Anonymous — Tue, 21 Mar 2017 08:42:21 GMT

Hi eliton,
For you requirement, y ou can use method "ReplaceAll(string s1, string s2)" in tMap component expression.
Best regards
Sabrina

Re: To remove unnecessary characters in string

Anonymous — Sat, 19 May 2018 07:06:23 GMT

replaceAll function throws null pointer expression when no matching string found.

Re: To remove unnecessary characters in string

manodwhb — Mon, 21 May 2018 06:20:45 GMT

@ContactNitesh89,can you try the below one.

column_name==null ||"".equals(column_name) ? column_name : column_name.replaceAll("-morning","")

Re: To remove unnecessary characters in string

manodwhb — Wed, 23 May 2018 08:01:33 GMT

@ContactNitesh89,still do you have issue?