How to extract the right country info from the field?

• PasLe Choix

  Say Hey Kid

  Points: 665

  More actions

  February 14, 2020 at 10:00 pm

  #3726081

  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 4 years, 2 months ago by  PasLe Choix.
  • This topic was modified 4 years, 2 months ago by  PasLe Choix.
  • This topic was modified 4 years, 2 months ago by  PasLe Choix.
  • This topic was modified 4 years, 2 months ago by  PasLe Choix.

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  February 15, 2020 at 10:10 pm

  #3726213

  Thanks for posting your issue and hopefully someone will answer soon.

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