topic Re: [resolved] Splitting A String At The Last Space in Talend Studio

[resolved] Splitting A String At The Last Space

HLeyes — Fri, 16 Jan 2015 22:03:05 GMT

I have used Talend variables and expressions in tMap to split a string at the space, as in a normal name field. That works for most cases, where there is a first and last name. For example, "Mickey Mouse" can be split into "Mickey" as the First Name, and "Mouse" as the Last Name.
I would like to know if there is a way to split a string at the last space. I'd like to be able to take a string such as "John and Mary Jones", and split off the "Jones" part to become the Last Name, and "John and Mary" to be the First Name.
Thanks in advance!
HL

Re: [resolved] Splitting A String At The Last Space

Anonymous — Sat, 17 Jan 2015 05:09:44 GMT

Hi
Search the last index of space, and truncate the string, for example;
tFileInputDelimited--main--tMap--tlogRow
For first name:
row1.name.substring(0,row1.name.lastIndexOf(" "))
For last name:
row1.name.substring(row1.name.lastIndexOf(" ")+1)
Best regards
Shong

Re: [resolved] Splitting A String At The Last Space

HLeyes — Tue, 20 Jan 2015 22:05:08 GMT

Hi Shong,
Thanks very much for the code - that did it! I modified the expression to account for one-word names, and also to TRIM the string.
HL

Re: [resolved] Splitting A String At The Last Space

_AnonymousUser — Fri, 17 Apr 2015 08:00:18 GMT

Hi Hleyes.
Could you share your solution for future generations?
Thanks.
BR, one-in-need

Re: [resolved] Splitting A String At The Last Space

Anonymous — Fri, 17 Apr 2015 08:43:26 GMT

Hi JamesBrown
I suggest you to open a new topic for your question and describe it with more information, so you can gain more help from community users.
Best regards
Shong

Re: [resolved] Splitting A String At The Last Space

palkondatharun — Tue, 12 Mar 2019 12:36:28 GMT

please write the code for middle name

remaining two are working last and first