From: Nuno Tavares
Date: October 3 2012 10:32pm
Subject: Re: need list of country ISO code to demonyms
List-Archive: http://lists.mysql.com/mysql/228308
Message-Id: <506CBCF5.4000708@dri.pt>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ermmm... actually it was done from Firefox to OpenOffice Calc, on 
Ubuntu.. :-) I just mentioned Excel so you could get the idea... glad I 
could help, though :-)

-NT

Em 03-10-2012 23:21, Daevid Vincent escreveu:
> HA! No $hit! Well isn't that clever. I didn't know that you can highlight a
> table like that, and paste it into Excel. That darn Microsoft -- they think
> of everything! :) Thanks for the tip.
>
>> -----Original Message-----
>> From: Nuno Tavares [mailto:nuno.tavares@stripped]
>> Sent: Wednesday, October 03, 2012 3:10 PM
>> To: mysql@stripped
>> Subject: Re: need list of country ISO code to demonyms
>>
>> I don't have it, sorry.
>>
>> But it took me 10 seconds to copy & paste it to an Excel, so I could
>> save it as CSV and import it directly to MySQL. Further on, it'd be as
>> simples as JOIN by name with a table with ISO-to-country-names, which
>> you can fetch in hundreds of places, such as Wikipedia.
>>
>> -NT
>>
>>
>> Em 03-10-2012 22:22, Daevid Vincent escreveu:
>>> Anyone have a SQL dump or other programmatically useable map of country
>> ISO
>>> codes to demonyms?
>>> http://www.geography-site.co.uk/pages/countries/demonyms.html
>>>
>>> I can parse the strings I suppose there, but that's not quite as
> accurate,
>>> and ripping that out of the HTML page to parse seems painful too.
>>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql
>
>