Jump to content

Reformating Phone Numbers


This topic is 7562 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am a first time user of a Filemaker 3.0 Pro and I have a database that has Names, Addresses, & Phone Numbers in a list. The problem is that the Phone Numbers are a straight 10 digits (without the hyphens). I need to reformat the field to include the hyphens. There are approximately 3400 entries on this list. Too many to add 1 at a time. Is there a way to add the hyphens to the numbers all at once. I am using Windows 98 and am a relative novice to computers, but do possess some very basic skills.

Link to comment
Share on other sites

Put the field on a layout, put your cursor in it, then go to Records->Replace and select 'Replace with calculated result'. Paste this calc into the Specify dialog and substitute phone with your field name:

Left( phone, 3 ) & "-" & Middle( phone, 4, 3 ) & "-" & Right( phone, 4 )

Link to comment
Share on other sites

This topic is 7562 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.