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
split in to many rows
Moderators: chulett, rschirm, roy
![Confused :?](./images/smilies/icon_confused.gif)
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers