K
Kamitsukenu
Hi there,
I would like to create a way of extracting country names from data received
from outside of the company that I work for, but am having trouble doing so.
Currently I have a form that, on clicking a button, will run a bunch of
queries which will check against a table which contains the names of the
countries, and some variant names (eg UK, United Kingdom, England etc etc.).
This seems okay if the quantities are low, but there have been times where
there have been 100k+ records, which kills processing time.
What is the best way of tackling this? There are other problems like the
country name isn't isolated in its own field, the country name can be in
different columns, and so on...
Any help will be gratefully received!
I would like to create a way of extracting country names from data received
from outside of the company that I work for, but am having trouble doing so.
Currently I have a form that, on clicking a button, will run a bunch of
queries which will check against a table which contains the names of the
countries, and some variant names (eg UK, United Kingdom, England etc etc.).
This seems okay if the quantities are low, but there have been times where
there have been 100k+ records, which kills processing time.
What is the best way of tackling this? There are other problems like the
country name isn't isolated in its own field, the country name can be in
different columns, and so on...
Any help will be gratefully received!