topic Re: replace multiple special characters in Talend Studio

replace multiple special characters

karandama2006 — Sat, 16 Nov 2024 04:42:51 GMT

Hi All ,

How can we replace multiple special characters or chain the replaceAll statement.

For eg :

I want to replace ß with s

and ° with ?

in the same column

is there any chaining which we could do ?

For eg :

row1.theStringYouWishToTransform.replaceAll("[ß]", "s").replaceAll("[°]", "?")

or we need to use two tmaps ? (Hopefully not)

TRF — Wed, 11 Sep 2019 08:29:08 GMT

Just 1 tMap with the following expression is enough:

(row1.theStringYouWishToTransform.replaceAll("ß", "s")).replaceAll("°", "?")

If you don't have anything else to do inside the tMap, a single tJavaRow is better:

output_row.theStringYouWishToTransform = (input_row.theStringYouWishToTransform.replaceAll("ß", "s")).replaceAll("°", "?");

TRF — Thu, 12 Sep 2019 09:22:35 GMT

@karandama2006, does this help?

If so, thank's to mark your case as solved.

karandama2006 — Thu, 12 Sep 2019 09:24:41 GMT

Yes it helps , Thank you

TRF — Thu, 12 Sep 2019 09:26:18 GMT

You're welcome!