Removing illegal characters for a Numeric Custom Field

If you have a value in an email such as $1,300.50 you may like to extract the numeric component and store in a suitable Numeric Custom Field.

 

Using the RegexpFP, just selecting the content of 1,300.50 will cause a failure when loading into the NumericCF type, it wont accept ','.  To work around this the following selector can be used:

 

bla bla ([0-9\.]*) bla bla

 

This then only matches numeric and decimal point characters, commas and any alphabetical and symbolic characters would not match.  Its possible even with this that multiple . characters would be present, this will still break.