Syntax
EXTRACT_MONEY(<text>)
Description
Extracts money from text and returns the results in a list.
Example
EXTRACT_MONEY(#Text_Column)
Text column | EXTRACT_MONEY returns |
---|---|
The costs of this project will be $1000 | [1000] |
Customers will pay $5 for each item. | [$ 5 for] |
During 2012, the company made $2,000,000 | [$ 2 , 000 , 000] |
During 2012, the company made 2 million dollars. | [2 million dollars] |