EXTRACT()

Extract values from text

Returns the list of values extracted from text.

Sample usage

EXTRACT("PRICES", "So, we've got a frappuccino for $3.49, a chocolate muffin for $2.49, and a chocolate milk for 99 cents, for a total of $6.97. Will that be all?") returns 3.49, 2.49, 0.99, 6.97 (list of Price)

EXTRACT("DATETIMES", "Set a meeting for November 14th at 4pm") : 11/14/2019 16:00:00 (list of DateTime)

EXTRACT("EMAILS", "Mailing List: [email protected], [email protected], [email protected]”) returns [email protected], [email protected], [email protected] (list of Email)

Syntax

EXTRACT("text", text-to-extract-from)

  • text - Literal text value to be extracted. Note that the argument must be in uppercase and enclosed in quotes to avoid confusion with reserved words. This argument may not be an expression. Choose one of CHOICE, DATES, DATETIMES, DOMAINS, DURATIONS, EMAILS, HASHTAGS, MENTIONS, NUMBERS, PHONENUMBERS, PRICES, or TIMES.

  • text-to-extract-from - Any textual value from which a list of the chosen type of values is to be extracted.

Notes

The type of list corresponds to the text you are extracting; for example, EXTRACT("NUMBERS", [TextColumn]) returns a list of Number values,
EXTRACT("DATETIMES", [TextColumn]) returns a list of DateTime values, and so on.

See also

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDOMAINS()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

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