Re: text imports
| From: | Wagner Tomy | Date: | Tue, 07 Aug 2001 11:06:04 +0000 |
| Subject: | Re: text imports | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-61583@lists.php.net to get a copy of this message | ||
ah k,
yes that's the way to do it in SQL ;p
Tomy Wagner
Web Developer
Editus S.A.
----- Original Message -----
From: "Karl Phillipson" <Karl@SaffronHill.com>
To: <php-general@lists.php.net>
Sent: Tuesday, August 07, 2001 1:08 PM
Subject: 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
>