EXTRACTPHONENUMBERS()

Extract list of phone numbers within a 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()

EXTRACTDOMAINS()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

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
3649217775682860016
true
Search Help Center
true
true
true
false
false