How to extract the right country info from the field?

  • This is very painful to me, I have a list of location and need to determine as much/close as possible(no need to be 100% accurate) for its country info, sample as below and two files attached here: one has 100 records, the other is the full list.

    San Diego, CA, United States
    Chicago, IL, United State
    New York, United States
    San Francisco, CA
    Kirkland, WA
    Colorado, USA
    London, UK
    Winston-Salem, NC
    Boston, MA
    Guatemala
    France
    New Jersey
    Hong Kong
    HongKong

    Note: London, UK is not a USA location though it is in the US pattern, and there are 'United State' and 'United States', the former is missing an 's'

     

    • This topic was modified 9 months, 2 weeks ago by  PasLe Choix.
    • This topic was modified 9 months, 2 weeks ago by  PasLe Choix.
    • This topic was modified 9 months, 2 weeks ago by  PasLe Choix.
    • This topic was modified 9 months, 2 weeks ago by  PasLe Choix.
    Attachments:
    You must be logged in to view attached files.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply