Area code update software program for ACT!, GoldMine, TeleMagic, dBASE, FoxPRO and ASCII format delimited files

Tired of calling Contacts from your database, only to find the area code changed? Then you need to have your database's area codes repaired with The Split Wizard! Split Wizard updates area code splits for any text database.

Fax lines and cell phones seemed to fill some area codes beyond capacity. In 1995, Bellcore instituted the North American Numbering Plan (NANP) to solve the problem by splitting designated area codes.

Area codes that are “full” are split into regions defined by the prefixes (the first three digits of the local phone number) and are changed to the new area code. For instance, in 1995 nearly four hundred prefixes in Georgia were changed to area code 770 while the rest of the prefixes remained 404. At the same time in Washington State, 300 prefixes were changed to 360 from 206.

Split Wizard works by checking your database phone numbers against its built-in table which now contains over 100 area code changes involving more than 20,000 prefixes.

 

Q.  How does Split Wizard know what phone numbers have been changed?  

• Area code splits are assigned by telephone prefix. When the split zone is created, all prefixes within the zone are assigned the new area code. So, in the case of Downey, California, 310-904-xxxx, the new phone number would be 562-904-xxxx because all phone numbers with the 904 prefix will use the new area code. 

• Split Wizard looks for every split since NANP went into effect January 1, 1995. However, in many cases of older splits, phone numbers have been reassigned. To decide whether a number should be changed or not, Split Wizard looks at the start date of the record. If the start date preceedes the split, then the record will be updated. Otherwise, you are prompted to see if the record might have been imported from an older list or another database. In any case, all splits since 1995 are covered, and you have control over how to handle the rare case where a telephone number might be reassigned. 

• They stopped changing area codes in approximately 2003. So if you have an older database, this works perfect, but only needs a one time update.

  List of many Area Code splits covered by Split Wizard:
  
  Anguilla 809 to 264 started March 31, completed September 30, 1997.
  San Diego 619 to 760 started March 22, completed September 27, 1997.
  Michigan, in Oakland County 810 to 248, completed September 13, 1997.
  Texas 817 to 940 and 254 completed August 24, 1997.
  Los Angeles 310 to 562 completed July 26, 1997.
  Central Indiana 317 to 765 completed June 28, 1997.
  Cincinnati suburbs and Dayton, Ohio 513 to 937 completed June 14, 1997.
  Montserrat 809 to 664 completed June 1, 1997.
  Suburban Houston 713 to 281 completed May 3, 1997.
  Southeastern Florida 407 to 561 completed April 13, 1997.
  British Columbia 604 to 250 completed April 6, 1997.
  Bahamas 809 to 242 completed March 31, 1997.
  Antigua and Barbuda 809 to 268 completed March 31, 1997.
  Suburban Dallas 214 to 972 completed March 14, 1997.
  Eastern Virginia 804 to 757 completed February 1, 1997.
  Puerto Rico 809 to 787 completed January 31 1997.
  Barbados 809 to 245 completed January 15, 1997.
  Chicago 312 to 773 completed January 11, 1997.
  Saint Lucia 809 to 758 completed January 1, 1997.
  Chicago 708 to 630 completed November 30, 1996.
  Upstate Connecticut 203 to 860 completed October 4, 1996.
  Bermuda 809 to 441 completed September 30, 1996.
  Minnesota 612 to 320 completed September 15, 1996.
  Southeastern Florida 305 to 954 completed August 1, 1996.
  Eastern Missouri 314 to 573 completed July 7, 1996.
  Oregon outside Portland 503 to 541 completed June 30, 1996.
  Northeastern Ohio 216 to 330 completed June 29, 1996.
  North and West Florida 904 to 352 completed May 20, 1996.
  South Carolina 803 to 864 completed May 1, 1996.
  Chicago 708 to 847 completed April 20, 1996.
  Southwestern Florida 813 to 941 completed March 3, 1996.
  Eastern Tennessee 615 to 423 completed February 26 1996.
  Western Virginia 703 to 540 completed January 27, 1996.
  Western Colorado 303 to 970 completed January 14, 1996.
  Atlanta outside the Perimeter 440 to 770 completed December 1, 1995.
  Arizona outside Phoenix 602 to 520 completed October 21, 1995.
  Western Washington State 206 to 360 completed August 20, 1995.
  Southern Alabama 205 splits to 334 completed March 13, 1995.
  Dominica 809 to 767 starting October 1st, 1997 will complete August 30th, 1998.
  British Virgin Islands 809 to 284 starting October 1st, 1997 will complete August 30th, 1998.
  Central Tennessee 615 to 931 completed January 19th, 1998.
  Southern Mississippi 601 to 228 started September 15th, 1997 will complete September 14th, 1998.
  Northern Massachusetts 508 to 978 completed December 1st, 1997.
  Suburban Boston 617 to 781 completed December 1st, 1997.
  Northeastern Ohio 216 to 440 and some additions to 330 completed April 4, 1998.
  Northern Kansas 913 to 785 started July 20, 1997 will complete October 3, 1998.
  Florida Panhandle 904 to 850 started June 23, 1997 completed March 23, 1998.
  Suburban Los Angeles 818 to 626 started June 14, 1997 completed February 21, 1998.
  Northern Silicon Valley/San Francisco 415 to 650 started August 2, 1997 completed February 1, 1998.
  Wisconsin 414 to 920 completed October 25, 1997.
  Southern Texas 210 to 956 and 830 completed October 6, 1997.
  US Virgin Islands 809 to 340 completed June 30, 1998.
  Central New Jersey 908 to 732 completed December 6, 1997.
  Northern New Jersey 201 to 973 completed December 6, 1997.
  Seattle area 206 to 253 and 425 completed November 16, 1997.
  Jamaica 809 to 876 started May 1, 1997.
  Arkansas 501 to 870 completed October 6, 1997.
  Northwestern Missouri 816 to 660 started October 12th 1997.
  Grenada and Carriacou 809 to 473 started October 31st, 1997.
  Southeast Michigan 313 to 734 started December 13th, 1997.
  Central California 916 to 530 will complete May 16, 1998.
  Dixon California 916 to 770 completed October 4, 1997.
  North Carolina 910 to 336 will complete June 15, 1998.
  Suburban Montreal 514 to 450 completed December 13, 1998.
  Oklahoma 405 to 580 completed April 1, 1998.
  Southeast Ohio 614 to 740 will complete June 6, 1998.
  South Carolina 803 to 843 will complete Sept 27, 1998.
  Orange County California 714 to 949 completed October 17, 1998.
  Utah 801 to 435 completed September 19, 1998.
  Pennsylvania 412 to 724 completed April 29, 1998.
  California 510 to 925 completed September 12, 1998.
  South Carolina 803 to 843 completed September 27, 1998.
  North Carolina 919 to 252 completed September 21, 1998.
  North Carolina 704 to 828 completed October 5, 1998.
  Alabama 205 to 252 completed September 27, 1998.
  California 714 to 949 completed October 17, 1998.
  California 213 to 323 completed January 16, 1999.
  Florida 813 to 727 completed February 1, 1999.
  California 408 to 831 completed February 20, 1999.
  Minnesota 612 to 651 completed January 10, 1999.
  Louisiana 504 to 225 completed April 5, 1999.
  California 209 to 559 completes May 15, 1999.
  Pennsylvania 717 to 570 completed April 4, 1999.
  Nevada 702 to 755 completes May 15, 1999.
  Alberta, Canada 403 to 780 completes May 18, 1999.
  California 805 to 661 completes August 14, 1999.
  Texas 512 to 361 completes September 18, 1999.
  Western Louisiana 318 to 337 completed 07/10/2000
  East Central Florida 407 to 321 completed 10/01/2000
  Suffolk County New York 516 to 631 completed 04/01/2000
  Eastern Tennessee 423 to 865 completed 04/24/2000
  Southeast Texas 409 to 936 and 979 completed 08/06/2000
  Minneapolis Minnesota 612 to 763 and 952 completed 01/14/2001
  Central Kentucky 606 to 859 completed 10/01/2000
  Southeastern New York 914 to 845 completed 12/03/2000
  Southeastern Iowa 515 to 641 completed 12/02/2000
  Southwest and Central Georgia 912 to 229 and 478 completed 08/01/2001
  Southern Kansas 316 to 620 completed 11/03/2001
  Western Tennessee 901 to 731 completed 09/17/2001
  Southeastern Louisiana 504 to 985 completed 10/22/2001
  Northern Florida 904 to 386 completed 11/05/2001
  Iowa 319 to 563 completed 12/02/2001
  Lower Michigan 517 to 989 completed 10/06/2001
  Virginia 804 to 434 completed 02/15/02
  Alabama 334 to 251 completed 01/07/02
  Arizona 520 to 928 completed 01/05/02
  Virginia 540 to 276 completed 03/16/02
  Michigan 810 to 586 completed 03/22/02
  Arkansas 501 to 479 completed 07/20/02
  Florida 941 to 239 completed 03/10/03
  Florida 561 to 771 completed 11/11/02
  Indiana 219 to 260 and 574 completed 06/13/02
  New York 716 to 585 completed 08/17/02
  Indiana 219 to 260 and 574 completed 06/14/02
  Arkansas 501 to 479 completed 07/20/02
  Florida 561 to 772 completed 11/11/02
  Florida 941 to 239 completed 03/10/03
  Michigan 616 to 269 completed 02/15/03
  Texas 915 to 325 and 432 to be completed 10/04/03
  

  SPLIT WIZARD PRICING

  We will update any database (up to 100,000 records) for a flat fee of $100. Just pay here and email your database. We will update it with the last area code update (2003) and email it back to you.

  Flat Rate Split Wizard Area Code Software Update - $100

  Return to Top

  ---

  

  Call today 1-800-LIST-GUY (547-8489)
  

  or 760-720-3941 or
  Email info@listguy.com