RE: [PHP] text imports

Yup, thanks Wagner. I can do this within PHP itself using trim or chop, I was hoping for a snippet of SQL code that would do it from the command line. This is what have done: LOAD DATA LOCAL INFILE 'C:\MYDIR\countries.txt' INTO TABLE DBNAME.COUNTRY LINES TERMINATED BY ',' (COUNTRY_NAME) ========================== Karl Phillipson PHP SQL Programmer Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 Direct Line: 0207 693 8318 -----Original Message----- From: Wagner Tomy [mailto:tomy.wagner@luxweb.lu] Sent: 07 August 2001 12:00 To: Karl Phillipson; 'Alexander Wagner'; MindHunter; php-general@lists.php.net Subject: Re: [PHP] text imports http://www.php.net/manual/en/function.chop.php Returns the argument string without trailing whitespace, including newlines Wagner Tomy Web Developer Editus S.A. ----- Original Message ----- From: "Karl Phillipson" <Karl@SaffronHill.com> To: "'Alexander Wagner'" <wagner@globalpark.de>; "MindHunter" <mindhunter@mailbox.co.za>; <php-general@lists.php.net> Sent: Tuesday, August 07, 2001 12:53 PM Subject: [PHP] text imports > Hi, > > I have been given a (notepad generated) text file which contains a list of > countries in a format such as: > > United Kingdom, > United States, > Blah, > Blah, > Blah, > > I have imported the data into a countries table in a mySQL database using > the excellent 'mysqlfront' prog. No probs on the import itself except for > some pesky pipes that I believe to be carriage returns. > > Anyone know a way I can strip these out so I have nice clean data. > > Ta in adavance. > > Karl > > > > Saffron Hill Ventures > 67 Clerkenwell Road > London > EC1R 5BL > > Saffron Hill: 0207 693 8300 > -- 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