EXTRACTPRICES()

Extract list of price values within a textual value

Returns a list of prices (Decimal values) within the textual value.

Sample usage

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)

Syntax

EXTRACTPRICES(text-to-extract-from)

• text-to-extract-from - Any textual value.

Notes

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.

See also

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDOMAINS()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTTIMES()