467,882 Members | 1,241 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

importing data with CR-LF

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
  • viewed: 2213
Share:
1 Reply
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.

Similar topics

9 posts views Thread by Stephen Saunders | last post: by
11 posts views Thread by Grim Reaper | last post: by
7 posts views Thread by Darren | last post: by
7 posts views Thread by Timothy Shih | last post: by
6 posts views Thread by mfoolb | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.