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 ofCHOICE
,DATES
,DATETIMES
,DOMAINS
,DURATIONS
,EMAILS
,HASHTAGS
,MENTIONS
,NUMBERS
,PHONENUMBERS
,PRICES
, orTIMES
. -
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.