DSXchange

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

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().

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