We have a field called number and the field number has both alpha and numeric values like "number=AVAILABLE=25 USD;" and the field number also has multi values like number=" CREDIT_PAYMENT=200.22 USD; DEBIT_PAYMENT=500.10 USD;" also it has null values like number=null
I want to extract all dollar amounts like 25 and 200.22 and 500.10 and create a new field. How can I achieve this?
Please help
Try and test against your data
|rex field=number max_match=0 "=(?<digits>\d+.?\d+|null)"