Regular expression help for Price

[bostonma]

Hello All,

can someone help me guide how I can add regular experession for a Price which is dynamic
For ex: Price is 8975 or 8975.99

I would like to add a checkpoint to make sure value is always >8500
How can I do this?

[jsknight1969]

This should do the trick.

Code:

(^[1-9]{1}\d{4,9}\.\d{2})|(^[8-9]{1}[5-9]{1}[0-9]{2}\.\d{2})

[manishbhalshankar]

Hi Bostonma,

Roundup the decimal no and then check if it is greater than 8500.

[bostonma]

JSKnight,

Can you please explain how the first part works?
(^[1-9]{1}\d{4,9}\.\d{2})|

[jsknight1969]

Sure.

It allows any number that starts with 1-9 and has at least 4 other digits before the ".". Basically it is to all 5+ digit numbers that don't start with zero. Any 5+ digit number would be automatically greater than 8500. That had to be allowed since the second part of the script only verified 4 digit numbers between 8500-9999.

having to explain this, I noticed an issue. Here is the updated expression.

Code:

(^[1-9]{1}\d{4,9}\.\d{2})|(^[8]{1}[5-9]{1}[0-9]{2}\.\d{2})|(^[9]{1}\d{3}\.\d{2})

Had to allow 4 digit number than begin with 9 as automatic too.

Part 1: allow 5+ digit number that do not start with "0"
Part 2: Allow 4 digit number that start with an 8 and has second digit between 5 and 9
Part 3: Allow 4 digit number that starts with 9

[bostonma]

Sorry for the delay in response.
ThankYou for the detailed explanation,definitely helps!

---

Jsknight,
I Tried with your code but error is displayed.Is the third part optional because in my case the value is 8500.So I'm wondering if it is looking for .9x?

[nanthini222]

To make the decimal point optional,

(^[1-9]{1}\d{4,9}[\.\d{2}]?)|(^[8]{1}[5-9]{1}[0-9]{2}[\.\d{2}]?)|(^[9]{1}\d{3}[\.\d{2}]?),

So it will work for 8585 as well as 8585.99 also

Thanks
Nanthini

[bostonma]

Thanks much Nanthini. It still failed and I noticed we have a dollar sign,comma and period at the end as well within Price.My bad I did not mention this before.

Ex: $8,599.97.

Can you be kind enough on how to accommodate these as well?please?
Again the period at the end should be optional as well.

[jsknight1969]

Hopefully this will do it

Code:

(^[\$]?[\d]{1,3}[,]?[\d]{3}[,]?\d{3}(\.\d{2})?$)|(^[\$]?[1-9]{1}[0-9]{1,2}[,]?\d{3}(\.\d{2})?$)|(^[\$]?[8]{1}[,]?[5-9]{1}[0-9]{2}(\.\d{2})?$)|(^[\$]?[9]{1}[,]?\d{3}(\.\d{2})?$)

This should allow anything > 8500 to 999,999,999.99. If you need a larger number than that it will have to be modified. it should also allow "$", "," and "." as optional, however if there is a decimal it must have 2 digits after.