SSNumb ( number )

Formats Social Security Number

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

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

Sample input:

SSNumb ( 123456789 )

Sample output:

123-45-6789

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

// remove any non-number

Let([
NumOnly= Filter(number; "0123456789");
    
SSNumb = Left(NumOnly;3) &"-"
             & Middle(NumOnly;4;2) &"-"  
             & Middle(NumOnly;6;99) 
];

//Set clolor to red if invalid number of digits.

If(Length ( NumOnly )  ≠  9 ; 
      TextColor ( SSNumb ; RGB ( 255 ; 0 ; 0 ) ); 
      TextColor ( SSNumb ; RGB (0 ; 0 ; 0 ))
))

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

Comments

		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 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) ]

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

SSNumb ( number )

Comments

Support this website.

Support this website.