EXTRACT_MONEY

Syntax

EXTRACT_MONEY(<text>)

Description

Extracts money from text and returns the results in a list.

Example

EXTRACT_MONEY(#Text_Column)

Text columnEXTRACT_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]
  • This function is not guaranteed to be 100% accurate.
  • The accuracy of results depends on both the training data being used by the function and the comparable quality of input data.
  • In order to assess result accuracy, you need conduct your own performance evaluation.