EXTRACTPRICES()

Extract list of price values within 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()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTTIMES()

 

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false