Re: [Sheflug] MySQL help

[Ruth Gunstone <xxxxx [at] xxxxxxxxxxxxxxxxxxxxxxxx>]

In message <5.1.0.14.0.20020424133652.00a1d2d0 [at] pop3.mail.griffin.net.uk>
          Steve Tickle <s.tickle [at] quarndon.co.uk> wrote:

> 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?).
[snip]
> 
> 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.
> 
[snip]

I've been doing some imports to MySQL recently, and (as far as I can tell!)
they appear to have gone o.k. - or rather they did /after/ I'd loaded the
data into a text/data editor (vim should do it?) and searched-out a load of
'odd' characters that the originating database had left behind (&OE). I
replaced them with a space (&20) and all was well.

Suggestion: Try dropping the excel data into another format first (say
Gnumeric? or the KOffice spreadsheet and see if that exports TSV more
efficiently/correctly?)

R.
-- 
Ruth Gunstone          (ruth at bolsterstone dot demon dot co dot uk)

 /====================================================\ 
 ||  Web-Site: http://www.bolsterstone.demon.co.uk/  ||
 \====================================================/
___________________________________________________________________

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

  GNU the choice of a complete generation.