EXTRACT()

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: 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.

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()