[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Sheflug] MySQL help

At 13:17 24/04/02 +0100, Will Newton wrote:

>The format I usually use for such things is CSV (by text, do you mean CSV?).
>CSV is fairly straightforward, but Excel can do silly things with it
>sometimes. If your data has any commas in it they will have to be escaped
>somehow, usually by being in quotes. Quoting and commas are usually the
>things that trip up parsers, some of them are horribly naive. Theres some
>pretty good packages for Perl that read CSV - it shouldn't be too hard to
>write an importer.

I've actually been saving the data as tab delimited text since the data 
actually contains spaces, commas and single quotes. The thing is that the 
data is getting skewed in the text file rather than being parsed 
incorrectly by MySQL. That's why I was wondering if I could export to a 
different file format and import that into MySQL.

I can try escaping the commas and single quotes and then saving it as a CSV 
file. Maybe that would work.

Thanks for your suggestions... Craig too.


Steve

___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.