Re: regex question
| From: | Kevin Beckford | Date: | Tue, 18 Jul 2000 19:26:24 +0000 |
| Subject: | Re: regex question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-7130@lists.php.net to get a copy of this message | ||
Alas, I see I have not been clear. The data literally looks like
"Boget, Chris",chris@wild.net,,,,,,,,,,,,,,
where the commas are fields which are empty.
so you see that the only quoted fields are ones with commas in them. Can LOAD
DATA deal with this? if so, how?
----- Original Message -----
From: Boget, Chris <Chris.Boget@wild.net>
To: 'Kevin Beckford' <kbeckford@bigorbit.com>
Cc: <php-general@lists.php.net>
Sent: Tuesday, July 18, 2000 1:54 PM
Subject: RE: [PHP] regex question
> > I tried LOAD DATA INFILE from mysql - I could not get it to
> > work. the problem is still the same as above. Anyone have any
> > code snippets or tips that I can try here? Situation is getting
> > desparate...
>
> load data infile '$fileName' into table mytable
> FIELDS ENCLOSED BY '\"' TERMINATED BY ',' LINES TERMINATED BY
> '\r\n'
> (field1, field2, field3, field4, ...)
>
> Chris
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>