Brian Dunning's FileMaker Custom Functions

SSNumb ( number )

Formats Social Security Number

  Average rating: 4.0 (32 votes) Log in to vote

Mike Williamson   Mike Williamson
Custom Database Design
http://pestaroo.com

Share on Facebook Share on Twitter

  Sample input:
SSNumb ( 123456789 )
  Sample output:
123-45-6789

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

Formats Social Security numbers in the format xxx-xx-xxxx. Results displays in red if improper number of numerical digits.

 

Comments

Barry Sommers   Barry Sommers, Staten Island NY
Apr 15, 2009
Unable to use the above calc code since it is for FM Advanced only. I am using "regular" FM 9.3. (Tried it... it won't work)

Do you have a calc code for auto formating SS numbers that will work with my version of FMP ???

Much appreciate any help you may offer.

Thanks,
Barry Sommers
w2bs@aol.com
 
John Leyman   John Leyman, Loma Linda, CA
Sep 20, 2011
You won't be able to make custom functions without FM Pro Advanced, but you can make a calculated field with the some formula:

Let([
NumOnly= Filter(number; "0123456789");

SSNumb = Left(NumOnly;3) &"-"
& Middle(NumOnly;4;2) &"-"
& Middle(NumOnly;6;4)
]
 

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.

Under construction. Email me your wish list for improvements.