Hi. I have a series of systems (contact center, fax, Cisco CUCM, etc) where phone numbers are returned in the data. The phone numbers can be represented by:
5-digit extension (ie. x22101)
10-digit NANP number (i.e. 3125551212)
11-digit NANP number (ie. 13125551212)
E.164 number (+13125551212)
For the moment, I am not concerned about #1 or #4, but I would like to do two things: Match only callers that have 10 or 11-digit phone numbers, strip the country code "1" when it shows up, and then leave only the area code for area code mapping.
Has anyone done this?
... View more