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()

Did this answer your question?