Env : SLQSERVER2000 - DTS
I want to import a text file with 3 fields in it ...
F1: Ident char(3)
F2: Note (Text) char(32,000) yeah big eh!
F3: Date
Field F2: has <CR><LF> thru it, this means the DTS import thinks its a
multiple records to deal with as each row is also delimited by <CR><LF>,
of course this causes problems when loading to the receiving table. The
import creates new records.
Hence is there a way to filter these formatting characters out easily
without disrupting the row delimiter. Using a VbScript, if anyone has
done this I'd be grateful of a copy of the script or utility.
The source of the file (IBM Iseries base app) cannot change the output
format.
Thanks in advance
Paul
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!