Returns a list of
Decimal values within the textual value.
EXTRACTNUMBERS("My name is Theo and I’m three and a half years old!") returns
3.5 (list of one
EXTRACTNUMBERS("Tommy: I left a message. Richard: Really, what number did you call? Tommy: Two, four, niner, five, six, seven…”) returns
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
97299 (list of two
text-to-extract-from- Any textual value.