Reference > Functions reference > Text functions > GetAsNumber
 
GetAsNumber
Purpose 
Returns only the numbers in text, as field type number.
Format 
GetAsNumber(text)
Parameters 
text - any text expression or text field containing numbers
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Use with formulas involving numbers or numeric functions. This function drops from text all non-numeric characters, leading zeros, and trailing zeros after the decimal point. If zero numeric characters are in text, returns an empty string.
You can also use this function to convert a date to the number of days. The returned number is the number of days since 1/1/0001.
Examples 
GetAsNumber ( "FY20" ) returns 20.
GetAsNumber ( "$1,254.50" ) returns 1254.5.
GetAsNumber ( "2 + 2" ) returns 22.
GetAsNumber ( SerialNumber ) returns 35684, when the value of SerialNumber is TKV35FRG6HH84.
GetAsNumber ( DateOfBirth ) returns 737342, when the DateOfBirth field contains 10/10/2019.
GetAsNumber ( Passcode )returns an empty string, when the Passcode field contains QTjPLeRMaCV.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas