Requirements:

1. enforce 2 digits after the decimal point - auto insert (.)00 if a regular integer entered e.g a 1 becomes 1.00
2. The products should always have a height and width > 0 so 0.01 is the smallest value the user should be able to input
3. maximum of 6digits before the decimal point
4. If a user enters .1 it should transform value to 0.10
5. If a user enters .12 it should transform value to 0.12

********EDIT*************
USE DECIMAL FIELD TO AUTO INSERT THE DECIMAL POINT & TRAILLING DIGITS
*******************************
These values are allowed/disallowed:

Allowed	Disallowed
0.01	0.00
123456.99	012345.00
12.00	12.0
119.75	119.759
99.00	99

Here's what I settled on for my custom regex:handler: price6pt2
field type: string
Length (property): 9 (to include decimal point '.')

Thanks @g1smd for all the help!

Gez

audibleid wrote: A Regular Expression cannot "transform" a value. It can only say whether what was entered matches the pattern, or not.
You'll need some extra code if you want to allow a user to enter 1 and it be changed to 1.00 or enter .1 and it be changed to 0.10, etc.

@g1smd

Sorry, that was a mistake in copying my requirements to the end of the thread to go with the updated expression!

Thanks for pointing it out.

BTW - if you want to auto add trailing digits past the decimal point even if they aren't entered, use a DECIMAL type field. The precision parameter handles the auto insertion of this.

Best,

Gez