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.

Take a look at this file Field Filters v7

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

Edited February 25, 200817 yr by Guest

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

Also for the basic concept here.

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

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.

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

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....

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