topic Parsing a Pipe delimited file ..... in Talend Studio

Parsing a Pipe delimited file .....

Anonymous — Fri, 20 Apr 2012 11:47:47 GMT

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

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

Anonymous — Fri, 20 Apr 2012 14:03:02 GMT

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.

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

Anonymous — Fri, 20 Apr 2012 22:22:26 GMT

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

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

Anonymous — Sat, 21 Apr 2012 17:18:08 GMT

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