List:General Discussion« Previous MessageNext Message »
From:Dave Stevens Date:October 3 2012 10:22pm
Subject:RE: need list of country ISO code to demonyms
View as plain text  
Quoting Daevid Vincent <daevid@stripped>:

> 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! :)

Hell, don't give them ideas! They'll be trying to patent cut and paste...

Dave

  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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>



-- 
If all the advertising in the world were to shut down tomorrow, would people
still go on buying more soap, eating more apples, giving their children more
vitamins, roughage, milk, olive oil, scooters and laxatives, learning more
languages by iPod, hearing more virtuosos by radio, re-decorating their
houses, refreshing themselves with more non-alcoholic thirst-quenchers,
cooking more new, appetizing dishes, affording themselves that little extra
touch which means so much? Or would the whole desperate whirligig slow
down, and the exhausted public relapse upon plain grub and elbow-grease?

--- Dorothy L Sayers, in Murder Must Advertise


Thread
need list of country ISO code to demonymsDaevid Vincent3 Oct
  • Re: need list of country ISO code to demonymsNuno Tavares3 Oct
    • RE: need list of country ISO code to demonymsDaevid Vincent3 Oct
      • RE: need list of country ISO code to demonymsDave Stevens3 Oct
      • Re: need list of country ISO code to demonymsNuno Tavares3 Oct