Newbies SlotcarBob Posted February 25, 2008 Newbies Share Posted February 25, 2008 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. Link to comment Share on other sites More sharing options...
Lee Smith Posted February 25, 2008 Share Posted February 25, 2008 Take a look at this file Field Filters v7 Link to comment Share on other sites More sharing options...
Newbies SlotcarBob Posted February 25, 2008 Author Newbies Share Posted February 25, 2008 (edited) TY, Lee. Cannot visit that page with Safari (Mac OS). Or Firefox. All software and OS is latest. Edited February 25, 2008 by Guest Link to comment Share on other sites More sharing options...
Lee Smith Posted February 25, 2008 Share Posted February 25, 2008 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted February 25, 2008 Share Posted February 25, 2008 Also for the basic concept here. http://www.filemaker.com/help/FunctionsRef-345.html Link to comment Share on other sites More sharing options...
Newbies SlotcarBob Posted February 25, 2008 Author Newbies Share Posted February 25, 2008 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. Link to comment Share on other sites More sharing options...
mr_vodka Posted February 25, 2008 Share Posted February 25, 2008 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 Link to comment Share on other sites More sharing options...
Anuviel Posted April 10, 2008 Share Posted April 10, 2008 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.... Link to comment Share on other sites More sharing options...
Lee Smith Posted April 10, 2008 Share Posted April 10, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5885 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 accountSign in
Already have an account? Sign in here.
Sign In Now