Examples
EXTRACTNUMBERS("My name is Theo and I’m three and a half years old!"): LIST(3.5)
EXTRACTNUMBERS("Tommy: I left a message. Richard: Really, what number did you call? Tommy: Two, four, niner, five, six, seven…”): LIST(2, 4, 5, 6, 7) (Note: niner is not a number!)
EXTRACT("NUMBERS", "The address is 330 SW Main St, 97229”): LIST(330, 97299)
Syntax
EXTRACTNUMBERS(“text-to-extract-from”)
Arguments
text-to-extract-from (text)
Return Value
A list of Decimal values.
See Also
EXTRACT(), EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()