Formatting Phone # input

[SlotcarBob]

I am wondering if I can just type in 7777777777, and get 777-777-7777? How would I format for this? Thank you.

note: I am a total novice.

[Lee Smith]

Take a look at this file Field Filters v7

[SlotcarBob]

TY, Lee. Cannot visit that page with Safari (Mac OS). Or Firefox. All software and OS is latest.

Edited February 25, 2008 by Guest

[Lee Smith]

ok, sorry.

Go to the Top of the Page here, and click on [color:blue](Examples) DatabasePros.com

When you reach the site, click on [color:red]Main Site

Then [color:red]Resources

and do a search for Filter Fields

HTH

Lee

[mr_vodka]

Also for the basic concept here.

http://www.filemaker.com/help/FunctionsRef-345.html

[SlotcarBob]

All these are great, but...

1. First, I am such a novice. Still crawling along.

2. The phone formatting is for removing anything but numbers. Not dropping in "-" where needed. Is there some clever way to do this? Maybe an Applescript? I am a Mac user. Thanks.

[mr_vodka]

Perhaps you missed this part of the help file?

The following example removes all text from the provided data, then formats the remaining numbers in the preferred phone number formatting:

Let(phone = filter(theField;"0123456789");"(" & left(phone;3) & ")" & middle(phone;4;3) & "-" & middle(phone;7;4))

If theField contains Work: 408.555.1212 this calculation returns (408)555-1212

[Anuviel]

The phone formatting is for removing anything but numbers. Not dropping in "-" where needed.

If you want to remove anything but numbers I do not see how that has connection with your first question

I am wondering if I can just type in 7777777777, and get 777-777-7777? How would I format for this?

The examples provided by others that replied solve your issue for the original question as far as I can tell but the second one about removing anything but numbers - if you remove anything but numbers you cannot have 777-777-7777 as - is not a number or I am totally missing your point....

[Lee Smith]

I don't know why you are confused. Click on this Link.

When the Site comes up, Click on "Main Site"

Click on Resources

find the Find Files, Tips and Articles:

Type in

Field Filters v7

click on the icon for your platform

find it on your hard drive.

Open it up, and look at the calculation for Phone Numbers

HTH

Lee