D
DataGuy0722
I would like to associate actual dialed telephone numbers in one table to a
country code/city code/mobile code name directory in another table by means
of finding a "best match" in the dialed telephone number string from the
left-most to right-most text position. All the data are in text format - not
numeric. I am just trying to identify the country/city/mobile destination of
each individual call in my telephone call records. I am using the Access
query function but it attempts to find an exact match for all 10 text
characters in Table 1 which I do not want - all I need is for the first few
characters in Table 1 to match those in Table 2 and return the related
country/city/mobile name that matches it best.
Example, for calls to France:
Table 1 - Our actual call records
Call #1: 33155557777
Call #2: 33612341234
Call #3: 33845458989
Call #4: 33785857878
Table 2 - My country/city/mobile reference table
33 - France
331 - France (Paris)
336 - France (mobile)
My desired result:
33155557777 - France (Paris)
33612341234 - France (mobile)
33845458989 - France
33785857878 - France
Appreciate any info you can share on how to accomplish this.
country code/city code/mobile code name directory in another table by means
of finding a "best match" in the dialed telephone number string from the
left-most to right-most text position. All the data are in text format - not
numeric. I am just trying to identify the country/city/mobile destination of
each individual call in my telephone call records. I am using the Access
query function but it attempts to find an exact match for all 10 text
characters in Table 1 which I do not want - all I need is for the first few
characters in Table 1 to match those in Table 2 and return the related
country/city/mobile name that matches it best.
Example, for calls to France:
Table 1 - Our actual call records
Call #1: 33155557777
Call #2: 33612341234
Call #3: 33845458989
Call #4: 33785857878
Table 2 - My country/city/mobile reference table
33 - France
331 - France (Paris)
336 - France (mobile)
My desired result:
33155557777 - France (Paris)
33612341234 - France (mobile)
33845458989 - France
33785857878 - France
Appreciate any info you can share on how to accomplish this.