Sequential files in the report format

[pkl]

Hi,

I was just wondering whether we can read the sequential file which is in a report format. I mean it has a recurring header and it is neither delimited or fixed width.


Any ideas?


Thanx
Preethi

[kduke]

You would have to treat the whole row as one column then use constraints to ignore the heading rows. In a second transformer parse the row into columns using substring() or field().

[tonystark622]

In a second transformer parse the row into columns using substring() or field().

Or use a Row Splitter stage instead of the second transformer to split the data out into columns (v7.1).

Tony