topic Re: How to split a field with comma separated values in Talend Studio

How to split a field with comma separated values

Anonymous — Sat, 16 Nov 2024 13:01:26 GMT

I have a csv file that I need to transform and export out a NEW csv file.
My current path is:
tFileInputDelimited_1 --> tMap_1 --> tBufferOutput_1 --> tFileOutputDelimited_1

The column, "Full Name" has "Last Name, First Name" in one string and i need to extract both names and place them into two different columns.
Is there a TRIM function i am missing that will allow me to trim from the comma in the string?

Re: How to split a field with comma separated values

Anonymous — Wed, 23 Mar 2011 08:26:03 GMT

Hi davidag1,
Maybe a look at the tExtractRegexFields component will give you a clue.
For instance : https://community.talend.com/t5/Design-and-Development/java-lang-NoSuchMethodError-routines-Numeric-resetSequence/td-p/83600
PS : Your tBufferOutput is maybe not mandatory in this kind of job
Regards,
Cyril

Re: How to split a field with comma separated values

Anonymous — Wed, 23 Mar 2011 20:23:15 GMT

Column Name: Full_Name
e.g. Full_Name = Gonzalez, David
I am trying to use the tExtractRegexFields with the following command

^(?<LastName>\w+),\s?(?<FirstName>\w+)$

Which works with in Regex Builder but not in tExtractRegexFields -- it complains "Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\)
Any ideas?

Re: How to split a field with comma separated values

Anonymous — Wed, 23 Mar 2011 20:28:59 GMT

Avoid the regex for such simple split... just use tExtractdelimfields to generate two field out of one....

Re: How to split a field with comma separated values

Anonymous — Wed, 23 Mar 2011 21:18:35 GMT

thx emaxt6
I got the job to work with the following:
tFileInputDelimited_1 --> tExtractDelimitedFields_1 --> tMap_1 --> tFileOutputDelimited_1

Re: How to split a field with comma separated values

alevy — Thu, 24 Mar 2011 01:33:01 GMT

Re your problem with tExtractRegexFields: remember that \ is an escape character for Java and regex so to use a regex shorthand character class such as \w in Talend (Java), you need \\w.

Re: How to split a field with comma separated values

Anonymous — Thu, 24 Mar 2011 20:57:20 GMT

Thank you alevy!