Dropped lines when NULL ascii value in text file

daiondoroga's Avatar
Go4Expert Member

My problem is that I have to process a special text file every day which contains 0 ASCII values to separate fields. The DTS import program drops everything after the ascii 0 value in the row, but of course I need the entire row with all fields.
So how can I prevent the text file import task from dropping everything after the 0 ascii value?

Could you help me in this?

Thank you
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
ASCII value of NULL is 0 i.e. '\0' so if you are reading from a file each field will come as one line or string so you re read it and you should get the next field.