FileMaker Pro Custom Functions

// Returns the type of common data: integer, integer range, date, date range, email, phone, text // by Matt Navarre 1/7/08. DataType Version 1.0 Let ([ integer = Int (stuff) ; date = GetAsDate (stuff) ; filter date = Filter (stuff ; "0123456789-/.*") ; filter phone = Filter (stuff ; "0123456789-/() " ) ; filter integer = Filter (stuff ; "0123456789" ) ; filter decimal = Filter (stuff ; "0123456789.-") ; len = Length (stuff) ; range = PatternCount (stuff ;"..") ; slashcount = PatternCount (stuff ; "/" ) ] ; Case ( IsEmpty (stuff) ; "null" ; filter date = stuff and slashcount = 2 and range = 1 ; "date range" ; filter date = stuff and slashcount = 4 and range = 1 ; "date range" ; filter date = stuff and slashcount = 1 and len ≤ 5 ; "date" ; // date in current year, such as 7/23 filter date = stuff and slashcount = 2 and len ≤ 10 ; "date" ; // date with year, such as 7/23/08 filter integer = stuff and GetAsNumber (stuff) < 99999 ; "integer" ; // this could also be a 5 digit zip code filter integer = stuff and GetAsNumber (stuff) > 99999 ; "large integer" ; filter decimal = stuff and range = 1 ; "integer range" ; filter decimal = stuff ; "decimal" ; filter phone = stuff and Length ( filter integer ) = 10 ; "phone" ; filter phone = stuff and Length ( filter integer ) = 7 ; "phone" ; PatternCount (stuff ; "@" ) = 1 and PatternCount (stuff ; ".") ≥ 1 ; "email" ; "text" // ain't none of the above, so it's prolly text ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.