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?
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})
Hi Bostonma,
Roundup the decimal no and then check if it is greater than 8500.
JSKnight,
Can you please explain how the first part works?
(^[1-9]{1}\d{4,9}\.\d{2})|
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
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?
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
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.
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.