Split rows of data after special characters

[Anonymous]

Hai,
How do I do if I have a row of data such that 10.2.3.123 and I wanted it to be into a new column with :
Column A | Column B | Column C | Column D
10           | 2            | 3            | 123
Would you mind to give me some advice?
Thank You in Advance,
ZO

[Anonymous]

Hi,

Have you tried component TalendHelpCenter:tExtractDelimitedFields?
Best regards
Sabrina

[Anonymous]

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.

[Anonymous]

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).

[Anonymous]

Sorry..

[Anonymous]

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 :

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

Hi yana_isma,

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

Best regards
Sabrina

[Anonymous]

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