Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fastload question: CRLF in field

Status
Not open for further replies.

morphik

Programmer
Dec 9, 2005
1
PL
Hi,

Is there any possibility to load vartext file with new line character in field? My source database has a special 'comment' field containing CRLF chars. After exporting data to pipe-delimited file FastLoad crashes on this field.

Any help will be appreciated.

M.
 
Hi morphik,
the only way i can think of is using an INMOD to read the input file and then pass the comment field as a Varchar to FastLoad.

Dieter
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top