EXTRACT()

Extract values from text

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

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: a@a.com, b@b.com, c@c.com”) returns a@a.com, b@b.com, c@c.com (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.

See also

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

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