topic Re: Removing characters before second occurence of space using tMap in Talend Studio

Removing characters before second occurence of space using tMap

Anonymous — Mon, 27 Mar 2017 07:21:13 GMT

Hi Anyone,

I just wanted to ask if how could I remove all the characters before the second occurrence of space in a string using tMap?

For example:
Input: "This is a sentence"
Ouput: "a sentence"
Thanks!

Re: Removing characters before second occurence of space using tMap

TRF — Mon, 27 Mar 2017 08:55:21 GMT

Hi,

Maybe not the better way but should work:

row1.sentence.replaceAll("^.* ", "").replaceAll("^.* ", "")

Regards,
TRF

Re: Removing characters before second occurence of space using tMap

Anonymous — Mon, 27 Mar 2017 17:58:06 GMT

You may write routine which can return the position and use the same in the substring method to get the desired output.
or alternatively by overloading the indexof method and use expression like this : row1.Input.indexOf(" ", row1.Input.indexOf(" ")+1) to get the index position of the 2nd space and use the value in substring to get the desired string: row1.Input.substring(Var.var1+1)
Also for a generic solution of index location look up ordinalIndexOf method in here

Re: Removing characters before second occurence of space using tMap

Anonymous — Tue, 28 Mar 2017 01:12:14 GMT

Hi TRF,
Thank you for your reply. Sorry for not responding right away. I've been experiencing connectivity issues.
Hi rana.abhimanyu90,
Thank you for helping me again, let me try to use your approach. Thanks!

Re: Removing characters before second occurence of space using tMap

Anonymous — Tue, 28 Mar 2017 01:34:31 GMT

Hi rana.abhimanyu90,
This helped resolve my issue. Also, thank you for the additional info. Thanks!