topic Re: Split rows of data after special characters in Talend Studio

Split rows of data after special characters

Anonymous — Wed, 31 Dec 2014 09:58:06 GMT

Re: Split rows of data after special characters

Anonymous — Wed, 31 Dec 2014 10:36:44 GMT

Hi,

Have you tried component TalendHelpCenter:tExtractDelimitedFields?
Best regards
Sabrina

Re: Split rows of data after special characters

Anonymous — Mon, 05 Jan 2015 02:08:23 GMT

Hi Sabrina,
Is it proper to use tExtractDelimitedFields? My source is not a delimited file, it is from a column in a database that I need to extract the data from the column.

Re: Split rows of data after special characters

Anonymous — Mon, 05 Jan 2015 06:23:47 GMT

Yes, Sabrina told you exactly what you need. Read the content which is actually delimited in a column and use this column in the mentioned component as input field. This content will be separated into new columns based in the delimiter (in your case the pipe).

Re: Split rows of data after special characters

Anonymous — Mon, 05 Jan 2015 08:22:00 GMT

Sorry..

Re: Split rows of data after special characters

Anonymous — Mon, 05 Jan 2015 09:17:22 GMT

hi, all..
i have tried the job using tFileInputDelimited which suggested before.
Source = 1.2.3.4.5 in single row by excel. The problem is the output not exist at that column.
Output = one| two| three| four| five
1 | 2 | 3 | 4 | 5
the output like image below :

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 02:31:09 GMT

Hi All,
It seems that extractdelimitedfields did not split the data into new column? Is there any other setting in the component that I should figure out?Would you mind to help me?

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 03:04:49 GMT

Hi zo,
Actually, you should use "\\ ." in field separator.
Best regards
Sabrina

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 03:11:36 GMT

Hi yana_isma,

For your actual result, could you please show us your schema setting screenshot of tExtractDelimitedFileld?

Best regards
Sabrina

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 03:20:56 GMT

Hi Sabrina,
thank you for your reply. It is working fine if we put "\\." instead of ".". may I know why should we put \\?
Thanks,
zo

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 03:36:34 GMT

Hi, Sabrina..
Thank you..i already got the answer for my problem just now..
Thank you again for your helps..
Thanks,
Yana_Isma

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 04:04:22 GMT

Hi zo,
Since tExtractdelimitedfields component uses regex to split a filed and the regex syntax uses special characters as operators, make sure to precede the regex operator you use as a field separator by a double backslash. For example, you have to use "\\|" instead of "|".
Best regards
Sabrina

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 04:15:48 GMT

Hi Sabrina,
Thank you so much for your help.
Regards,
zo

Re: Split rows of data after special characters

Anonymous — Wed, 07 Jan 2015 06:09:30 GMT

Hi zo,
Could you please mark this topic as resolved?
Best regards
Sabrina