Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

StripCharacters ( field )

Removes formatted characters from a phone number

  Average rating: 4.6 (20 votes) Log in to vote

Michael Rocharde Ad-Minimum http://www.michaelrocharde.com

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* This function is very useful if you want to send out SMS message from your FileMaker solution using a Twilio account and the HTTP Post function*/ Substitute(field;["-";""];["(";""];[")";""];[" ";""]) Click to copy

Sending out SMS messages from FileMaker, using the HTTP Post function and a Twilio account is very easy but you need to have the cell phone number stripped down to 10 characters. This function removes the normal characters found in a formatted phone number.

 

Comments

		Hisc, noplace Oct 12, 2015
Why not just use Filter ( text ; "0123456789" ) ? I ran some test and Substitute seems to be (insignificantly) slower. Also, Filter would be less error prone if all you need is the numbers.

		Michael Rocharde, Denver, CO Oct 12, 2015
That's a very good point. I should have thought of using Filter. Thanks.

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: