Flat file to be used which has NEWLINE entry problem

vivek · Post by **vivek** » Tue May 30, 2006 1:26 pm

I have a flat file and I am trying to load it into a hashed file. The problem I am facing is due to numerous Enter key strokes or new lines made by the data entry guys, resulting in misplaced columns. How should I go about this issue?

thanks in advance

chulett · Post by **chulett** » Tue May 30, 2006 1:39 pm

One possible solution would be to scroll your Sequential File stage's Column tab over to the left so you can see the 'hidden' goodies on the right-hand side. One is 'Contains terminators' and when set to yes for a particular column will allow you to read terminators in that column as data.