Reading Pipe Delimited, Variable Length, EBCDIC file
Posted: Thu Feb 24, 2011 3:43 am
Hello All,
We have a requirement for reading a Pipe Delimited, Variable Length, EBCDIC file. I am using a CFF stage for the same.
Things done
1) File layout imported
2) Record Type set as "Variable"
3) Character Set kept as "EBCDIC"
But where do we specify the Field delimiter in a CFF stage? I see an option called Record Delimiter. Tried changing that to a pipe but then am not able to "View Data". Getting the following error
" Missing record delimiter "|", saw EOF instead"
Has anyone imported such a file??
Thanks,
Priya.
We have a requirement for reading a Pipe Delimited, Variable Length, EBCDIC file. I am using a CFF stage for the same.
Things done
1) File layout imported
2) Record Type set as "Variable"
3) Character Set kept as "EBCDIC"
But where do we specify the Field delimiter in a CFF stage? I see an option called Record Delimiter. Tried changing that to a pipe but then am not able to "View Data". Getting the following error
" Missing record delimiter "|", saw EOF instead"
Has anyone imported such a file??
Thanks,
Priya.