topic Re: Extract the string after the first space in Talend Studio

Extract the string after the first space

stephbzr — Fri, 15 Nov 2024 22:15:14 GMT

Hello,

I can't find a java method that allows me to extract the whole string after the first space. For example, I have strings :

- word1 word2 word3

- word1 word 2

I want to have

- word2 word3

- word2

Thank you

Re: Extract the string after the first space

Anonymous — Thu, 22 Dec 2022 11:39:52 GMT

try this

row1.name.contains(" ")?row1.name.substring(row1.indexOf(" ")+1):""

// this expression is used to check if the string contains blank space? if yes, extract the whole string after the first space, if no, return an empty string.

Regards

Shong

Re: Extract the string after the first space

stephbzr — Thu, 22 Dec 2022 13:18:02 GMT

Thanks for the help @Shicong Hong, it will be useful if I encounter this case in a tMap.

But I forgot to mention that I am looking to do this in a tWarn! In the context of a joblet, I use a context variable where the first word is always the same, but depending on the job, the second word varies.

I tried that, but without success

Re: Extract the string after the first space

stephbzr — Thu, 22 Dec 2022 13:39:04 GMT

I finally used your solution with tMap because I'm not sure if it works with tWarn. Thanks

Re: Extract the string after the first space

jlolling — Thu, 22 Dec 2022 20:04:58 GMT

I would use regex expressions to do that. There is a component tExtractRegexFields to handle regex.