?
Solved

Is there software to update phone area codes?

Posted on 1998-01-07
4
Medium Priority
?
258 Views
Last Modified: 2010-04-25
I have several files of phone and fax numbers in Filemaker (I can export into a text format if necessary).  Is there any software that will quickly and easily change old area codes to the new ones, either within the Filemaker format or in some other format?

Thanks!
0
Comment
Question by:DrPaul
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 3

Expert Comment

by:Jackie071497
ID: 1540745
You can export it to text format, then use the Eliza at :
http://www6.zdnet.com/cgi-bin/texis/swlib/mac/infomac.html?fcode=MC11621
to replace the old area codes.

0
 

Author Comment

by:DrPaul
ID: 1540746
I tried Eliza, but I would have to enter each of the old area codes, the telephone exchanges and the new area codes all by hand - which would take hours.  Then do a search and replace each time

I'm looking for software that will automate that whole process.  Software that already has the area code and exchange information loaded - something I can run a text file (or Filemaker file) of the old phone numbers through and come out with the new area code changes made to the file.  This would be a specific application just for updating area codes.
0
 
LVL 3

Expert Comment

by:Jackie071497
ID: 1540747
Try to concate all your files --> replace all area codes --> separate files
0
 
LVL 1

Accepted Solution

by:
themacman earned 400 total points
ID: 1540748
I don't believe there is anything that quite maches what you want to do. However, you could write a simple script in FileMaker Pro that *can* do this for you. It would take only 1/2 hour or so, maybe less.

Basically, you'd write a script that has all the old area codes and new area codes. The script would do a search on the area code field and compare it against this table, replace if there needs to be any changes.

There is one problem to be aware of, that is that many states (like California) have multiple area codes. In this case, you'd have to do a compare on the city name as well.

Hope this helps.
0

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
There is a security feature on iOS devices that is nearly impenetrable when it has been activated.  This article will provide some possible solutions as well as necessary steps to take to ensure you do not end up with a locked device.
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question