Examples

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 a List of Price: 3.49, 2.49, 0.99, 6.97. EXTRACT("PRICES", ...) is equivalent to EXTRACTPRICES(...). 

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

EXTRACT("EMAILS", "Mailing List: [email protected], [email protected], [email protected]”)  : [email protected], [email protected], [email protected]

Syntax

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

Arguments

thing-to-extract (literal text): The type of the value to be extracted as literal text value. Note that the argument must be in upper-case and enclosed in quotes to avoid confusion with reserved words. The argument may not be an expression. Choose one of CHOICE, DATES, DATETIMES, DURATIONS, EMAILS, HASHTAGS, MENTIONS, NUMBERS, PHONENUMBERS, PRICES, TAGS, or TIMES.

text-to-extract-from (any textual): Text from which a list of the chosen type of values is to be extracted.

Return Value

A List of values. The type of list corresponds to the thing you are extracting; for example, EXTRACT("NUMBERS", [TextColumn])  returns a list of Decimal values,
EXTRACT("DATETIMES", [TextColumn])  returns a list of DateTime values, etc. 

See Also

EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTNUMBERS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()

Did this answer your question?