Examples
EXTRACTNUMBERS("My name is Theo and I’m three and a half years old!"): 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…”): 2, 4, 5, 6, 7 (list of five Number values; note that niner is not recognized as a number)
EXTRACTNUMBERS("The address is 330 SW Main St, 97229”): 330, 97299 (list of two Number values)
Syntax
EXTRACTNUMBERS( text-to-extract-from )
Arguments
text-to-extract-from (any textual value)
Return Value
A list of Decimal values.
See Also
EXTRACT(), EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()