Note that “prices” in this case means only numeric values that are prefixed by a currency symbol (e.g. $, £, ¥, etc). If there's a demand for it, we may in the future offer an extract option that also gets all “currency-like-but-not-currency-symbol-prefixed” values as well. In the meantime, please see EXTRACTNUMBERS() if you’d like to get all number-like entities from your text.

Examples

EXTRACTPRICES("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?"): LIST($3.49, $2.49, $0.99, $6.97)

Syntax

EXTRACTPRICES(“text-to-extract-from”)

Arguments

text-to-extract-from (text)

Return Value

A list of Decimal values. 

See Also

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

Did this answer your question?