By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

importing data with CR-LF

P: n/a
I have a coma del text file that has an email that has to go into a
varchar(4000) . This email column has CR-LP and coma as part of the
text. when I try to import the table, i am getting a truncation error
and it reject the next line thinking its the next row.
How can I import column with CR-LF characters ?

thanks

roger

Aug 8 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Aug 8, 3:51 pm, Roger <wondering...@gmail.comwrote:
I have a coma del text file that has an email that has to go into a
varchar(4000) . This email column has CR-LP and coma as part of the
text. when I try to import the table, i am getting a truncation error
and it reject the next line thinking its the next row.
How can I import column with CR-LF characters ?

thanks

roger
I usually encapsulate text within a character that doesnt occur inside
data, like * or even ? and
use the MODIFIED BY CHARDEL& to specify the string delimiter
character. It works...

Aug 8 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.