text imports
| From: | Karl Phillipson | Date: | Tue, 07 Aug 2001 10:53:11 +0000 |
| Subject: | text imports | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-61578@lists.php.net to get a copy of this message | ||
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