Extract list of numeric values within a textual value
Returns a list of Decimal values within the textual value.
Sample usage
EXTRACTNUMBERS("My name is Theo and I’m three and a half years old!") returns 3.5 (list of one Decimal value).
EXTRACTNUMBERS("Tommy: I left a message. Richard: Really, what number did you call? Tommy: Two, four, niner, five, six, seven…”) returns 2, 4, 5, 6, 7 (list of five Number values; note that niner is not recognized as a number).
EXTRACT("NUMBERS", "The address is 330 SW Main St, 97229”) returns 330, 97299 (list of two Number values).
Syntax
EXTRACTNUMBERS(text-to-extract-from)
text-to-extract-from- Any textual value.
See also