Note that “prices” in this case means only numeric values that are prefixed by a currency symbol (e.g. $, £, ¥, etc). 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?"): $3.49, $2.49, $0.99, $6.97 (list of four values)

Syntax

EXTRACTPRICES( text-to-extract-from )

Arguments

text-to-extract-from (any textual value)

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?