Reading a Pipe Delimited file with variable columns

[Udaya1]

Hi,

I have a Pipe Delimited file with variable columns like shown below.

Row1 --column1|column2|column3|

Row2 --Column1|column2|column3|column4|column5|

Row3--colum1|column2|column3|column4|

Tried with different ways to read this file, able to read the file, but not able to do any further filter.

My requirement is based on column3 value, a different file to be created.

Any thoughts how to achieve this in Talend.

Thanks,

Uday

[manodwhb]

@udaya paduchuri​ , you can use tfilterrows component and you can filter and generate the required output file.

Thanks,

Manohar

[Udaya1]

@Mano--I tried that way, but the problem is the columns are not consistent, hence tfilter is not working.

[Ani1]

Hi Uday,

If you have the headers for all the 5 columns, then after reading the file you can use a tMap to split according to column 3 and output the result to separate files.

[Udaya1]

@Ani--Unfortunately, there are no headers for the columns.

Thanks,

Uday