EXTRACTNUMBERS()

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

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDOMAINS()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()