EXTRACTNUMBERS()

Extract list of numeric values within a 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()

EXTRACTDOMAINS()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()

 

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
2323892839505005103
true
Search Help Center
true
true
true
false
false