Posted by milagro on 10/06/05 16:09

Sure, Thanks!

The LOAD statement:

LOAD DATA INFILE '/home/data.csv' into table data2 FIELDS TERMINATED BY
',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';

The data string is very long. To simplify matters I'll give you and
example of the field whose data I'm having problems with:
"*955665"

That's it. Just a number that is preceded by a *

Thanks again,
Mike




In article <di2rbk$nn0$02$1@news.t-online.com>,
Ulf Wendel <ulf.wendel@phpdoc.de> wrote:

> milagro wrote:
> > I'm using LOAD DATA INFILE to import a text file containing several
> > thousand records. Some of the records have the asterik character (*) in
> > them. I notice that fields that contain that character are blanked out
> > when I look at the data that has been input. Is there some way using
> > LOAD DATA INFILE to allow the (*) character to be imported?
>
> Could you be more elaborative and post *one* (or two) example line from
> the text file and the LOAD DATA INFILE statement?
>
> Ulf

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

• Next in forum: Re: how to handle special asterik in input data
• Prev in forum: how to handle special asterik in input data
• Thread view: Re: how to handle special asterik in input data

[Reply to this message]