split in to many rows

[satisht]

hi

i have a job in which
i have a cff and there is no metadata for that and when i am trying to view the data it's not readable data and as it cff it is separated by commas(CSV),
and i want to put tha data after comma in next row and so on.
can u guys suggest which stage to use to split or we can do with a transformer

thanx in advance

[chulett]

By 'unreadable' do you mean EBCDIC or perhaps packed decimal fields like COMP-3? If that's the case, why not use the CFF stage to read it? And if you don't have the metadata for the file - get it. You'll be on a wild goose chase without it.

If you really want to read each field as a record, you'll need to play a game with the field separators. It involves reading the file in and writing it back out to a new name with record separators between the fields, then when you read it back in one more time you magically get what you are seeking. There is a FAQ in the FAQ Forum that details this method - something like 'Creating one record from many' or some such. Should be easy enough to find.

[chulett]

Writing multiple rows from 1 source row