EXTRACTPHONENUMBERS()

Extract list of phone numbers within textual value

Returns a list of phone numbers (Phone values) within the textual value.

Sample usage

EXTRACTPHONENUMBERS("Call Jenny, 555-867-5309!") returns 555-867-5309 (list of one item).

Syntax

EXTRACTPHONENUMBERS(text-to-extract-from)

  • text-to-extract-from - Any textual value. 

See also

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()

 

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