Returns a list of prices (
Decimal values) within the textual value.
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?") returns
$3.49, $2.49, $0.99, $6.97 (a list of four values)
text-to-extract-from- Any textual value.
Note that prices in this case means only numeric values that are prefixed by a currency symbol (such as $, £, ¥, and so on). 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, use
EXTRACTNUMBERS() if you’d like to get all number-like entities from your text.