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
