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 all non-numeric characters from text. 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(“FY98”) returns 98.
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 735516, when the DateOfBirth field contains 10/10/2014.
GetAsNumber(Passcode)returns an empty string, when the Passcode field contains QTjPLeRMaCV.
Related topics