SEO

#1 (**permalink**) 02-27-2008, 01:03 PM

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

#2 (**permalink**) 02-27-2008, 01:03 PM

On Aug 8, 3:51 pm, Roger <wondering...@gmail.com> wrote:
> 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...

#3 (**permalink**) 02-27-2008, 01:04 PM

Roger wrote:
> 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 ?

I know this is a very late answer, but if your fields have character
delimiters (the " in the default delimited format), you can use

modified by delprioritychar

On your load/import command. See the documentation for a better
description of this option.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

importing data with CR-LF