I just spent the last few days developing a system which converts 10-digit phone numbers to SMS emails. The system was moderately complex to get all the pieces working; however, is simple in design.
In a nutshell, the 10-digit phone number is referenced using the first 6 digits as a match parameter against a database of 165,000 records. Each record is matched to a carrier using the area code and phone number prefix (604-521-####) and is flagged if it is from a wireless network.
Each phone number is updated with City, State, Carrier, and Wireless Flag.
A second lookup is performed against the carrier to ensure the most accurate SMS Gateway is used. Considerable amount of work went into researching each old and new carriers’ of the blocks of cellphone numbers throughout the United States.
- Enables you to send SMS text messages to batches of cell phone numbers.
- The System coverts a phone number to a SMS email addresses in a batch process.
- During the batch non-wireless phone numbers are rejected.
- All matched carriers are updated with the most current SMS email gateway.
Out of 30,286 unique records entered into the system, 18,126 appeared to be matchable cellphones (There really are 277 more but I am too lazy to research and update the small carriers), and the breakdown of the wireless providers throughout the united states is as follows. This also provide a clear picture of who dominate the US cellphone market.
More comprehensive stats to come…
| cellcom.quiktxt.com | 47 |
| csouth1.com | 52 |
| einsteinsms.com | 17 |
| email.uscc.net | 844 |
| iws@iwspcs.net | 20 |
| messaging.nextel.com | 1729 |
| messaging.sprintpcs.com | 2541 |
| page.southernlinc.com | 12 |
| pcs.ntelos.com | 20 |
| sms.mycricket.com | 309 |
| tmomail.net | 1900 |
| txt.acsalaska.net | 61 |
| txt.att.net | 5148 |
| vtext.com | 5426 |
