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
Flat file to be used which has NEWLINE entry problem
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers