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?") :
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( "thing-to-extract" , text-to-extract-from )
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.
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.
EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTNUMBERS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()