Re: regex question

If you are using MySQL and PHP, then I suggest getting phpMyAdmin from http://www.phpwizard.com That program will do just about everything for you as far as managing a MySQL database is concerned. It'll do the LOAD DATA INFILE for you...you can even choose what the deliminator is. just my 2¢ randy ______________________________________________ http://www.randys.org http://www.iduh.com http://www.digifont.com For-pay Internet distributed processing. http://www.ProcessTree.com/?sponsor=11087 > From: "Boget, Chris" <Chris.Boget@wild.net> > Date: Mon, 17 Jul 2000 13:22:05 -0500 > To: "'Kevin Beckford'" <kbeckford@bigorbit.com>, GPHP > <php-general@lists.php.net> > Subject: RE: [PHP] regex question > >> Ok, I give up - help! >> I have to read data in exported from an Outlook Express >> address book. I have used file() on the address book file to get >> in into an \array. The data is CSV, and fields with commas are >> quoted. I am trying to use a regex to simply make a dynamic >> query string like this for each row. >> insert into $db_name('a','b',"hey, this is a quoted field >> with commas",.....) >> I am trying to use the PCRE to do this. How would I do this? > > There is a feature of mySQL (if that is what you are using; I'm > sure that most other flavors of SQL would have it but am unsure) > that you should look into and could make your life infinitely > easier: > > LOAD DATA INFILE > > it is a godsend for situation like this. > > 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 __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com