Solved

Is there software to update phone area codes?

Posted on 1998-01-07
4
255 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 200 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mails are getting deleted permanently from inbox and sent items 4 84
Two apple errors plaguing me 6 77
First crummy OS for the iPhone 3 64
Wireless coverage 7 115
Package creation on OS X uses the PackageMaker utility installed as part of the XCode development suite ( on the OSX Client CD).  Packages can be installed as part of the machine build process, or later using Apple Remote Desktop. They are generally…
Steve Jobs once said that Blu-ray is "a bag of hurt". As Macs users well known, things haven’t settled down (at least not from Apple’s perspective). Several years after that comment, Mac OS X still doesn’t support Blu-ray playback, nor has any Mac s…
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…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

756 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