EXTRACTNUMBERS()

Extract list of numeric values within textual value

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

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()

 

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false