topic Re: Splitting of String in Talend in Talend Studio

Splitting of String in Talend

RP1629548713 — Fri, 15 Nov 2024 21:28:45 GMT

Hi All ,

I need a small help . I have an input ,e.g : ABC : 123 which is completely in string as it is a file . The length of this input may vary or i can say is dynamic. I need to extract only the right hand part from based on the delimiter which is ": " and whatever comes after the delimiter i need to store. The input that comes before the delimiter needs to be excluded . Can you please help me ? I tried substring and lastIndexOf but this seems useful when you have fixed length,i donot have fixed length input . It can be of any length. if anyone can please suggest some java code it will be great. textractdelimitedfield would not help in my scenario.Only tmap or javacode would .

Re: Splitting of String in Talend

kakooo16 — Thu, 17 Aug 2023 12:17:51 GMT

You can use a tNormalize component and put ":" as your delimiteur

Re: Splitting of String in Talend

RP1629548713 — Thu, 17 Aug 2023 13:51:15 GMT

No ,I have already tried it ,doesnt help. I would rather require a regex or a routine

Re: Splitting of String in Talend

anselmopeixoto — Thu, 17 Aug 2023 14:41:48 GMT

Hello @Riya P

Supposing this String is in a column called "content" coming from a input called row1, what if you try the following:

row1.content.substring(row1.content.indexOf(":"))

The indexOf method returns the index of the first occurrence of ":" inside the source String and passes this index to the substring method, which you get all the String content after ":"

You can add +1 to this index to exclude the ":" from the result:

row1.content.substring(row1.content.indexOf(":")+1)

Re: Splitting of String in Talend

RP1629548713 — Thu, 17 Aug 2023 19:25:26 GMT

Hey hi, thanks for suggesting this way. I tried it but it's storing the 1st part of the string whereas I'm in need of the later

Re: Splitting of String in Talend

d_o — Thu, 17 Aug 2023 20:22:12 GMT

Along the same lines as what Ansel suggested, assuming your string was in Notes, you might try the following:

StringHandling.RIGHT(row10.Notes,((int)StringHandling.LEN(row10.Notes))-((int)row10.Notes.indexOf(":"))-1)

Re: Splitting of String in Talend

RP1629548713 — Fri, 18 Aug 2023 08:01:55 GMT

Works 🙂 Thanks !