Greetings,
I have a table that contains (among other things)fields for city, state and phone number.
In the phone number field, the numbers are strung together with no masks or ostensible non-numeric charecters.
I need to take that data and report on it. The idea is to ignore the area code of the phone number, but count the prefix and provide a total.
example:
Lets say I have an entry of 2015556789 for the city of Elko in the state Nevada.
The prefix of 555 and the location of Elko is the information I wish to gather.
Once gathered, I want to tally up the total number of matching prefixes and their matching city. The final result might be something like this:
Prefix | City | Total number of entries
555 | Elko | 50 entries
My greatest challenge so far is figuring out how to isolate the prefixes. How do I ignore the area code and get only the prefix?
Start Free Trial
