One Star

Parsing a Pipe delimited file .....

Hi,
I'm new to Talend ETL and was wondering if anyone could tell me which components I need to use to parse a pipe delimited file as so:
Read through pipe delimited file and parse as follows:
If record_type = 1 then output field1 to table1.field1, field2 to table1.field2 etc
If record_type = 2 then output field1 to table2.field1, field2 to table2.field2 etc
If record_type = 3 then output field1 to table3.field1, field2 to table2.field2 etc
etc.....
If a tMap how do I use the expression, or is it a tFilter?
Any help and a simple heads-up to get me started will be much appreciated.
Many thanks
Andy
3 REPLIES
One Star

Re: Parsing a Pipe delimited file .....

You want to use the tFileInputMSDelimited component. You will create record layouts for each record_type, and they will each have their own output from that component.
One Star

Re: Parsing a Pipe delimited file .....

Phobucket,
I was using Jasper ETL so didn't have the tFileInputMSDelimited, so I downloaded TOS and it works a treat, many thanks for your help.
Andy
One Star

Re: Parsing a Pipe delimited file .....

Hi Andy, Glad to help, welcome to Talend, and good luck.
-Ben