Reading file with undefined number of column

[RA6]

Hello Guys,

I have a csv file as input and i need to extract clients informations from it.

The information of each client data is between a block of lines and the problem is that there is no defined schema/number of columns/separator.

The only line that separate each client block information is the line below:

0------------------------------------------------------  END OF REPORT 4251  ------------------------------------------------------

Here is an example of a block of information for one customer:

My expected out put should be like this:

Is there a way to achieve this result?

Many thanks,

Duke

[Anonymous]

Hello,

With talend subscription solution, here is a dynamic schema feature which allows you to design schema with an unknown column structure (unknown name and number of columns).

Best regards

Sabrina