Validating an Amount Field

[Alec Lee]

I want to make sure a text field is any non-negative numeric value with 2 or less decimal point not less then say $100000. What is the simplest combination of the standard rules/regular expressions to achieve this with the validator?

Also, if I want to allow the user to optionally add commas like 10,000. What would the simplest combination of rules.

I guess the 'mask' rule has to be used with some regular expression. But my knowledge of regexpr is very little!

Thx for any advice.

[Brent Sterling]

Here are some expressions that I put together a while ago. I tested them at the time and they have been in use for a few years so I hope they work. Like you, I don't know much about regular expressions, but I was smart enough to add a comment.

<!--
    the following number regular expressions are based on the example at:
        <a href="http://www.pantz.org/scripting/perl/regex.shtml" target="_blank" rel="nofollow">http://www.pantz.org/scripting/perl/regex.shtml</a>
-->
<constant>
    <constant-name>standardMoneyFormat</constant-name>
    <constant-value>^([0-9]+|[0-9]{1,3}(,[0-9]{3})*)(\.[0-9]{1,2})?$</constant-value>
</constant>
<constant>
    <constant-name>standardDecimalNumberFormat</constant-name>
    <constant-value>^(-?[0-9]+|[0-9]{1,3}(,[0-9]{3})*)(\.[0-9]+)?$</constant-value>
</constant>
<constant>
    <constant-name>standardWholeNumberFormat</constant-name>
    <constant-value>^(-?[0-9]+|[0-9]{1,3}(,[0-9]{3})*)$</constant-value>
</constant>

- Brent