Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC:

[HOW T0] VALIDATE DECIMAL (MUST BE POSITIVE) 17 Nov 2012 18:53 #5438

  • JoomGuy
  • JoomGuy's Avatar Topic Author
  • Offline
  • Moderator
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
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:
AllowedDisallowed
0.010.00
123456.99012345.00
12.0012.0
119.75119.759
99.0099

Here's what I settled on for my custom regex:
^(0(\.(0[1-9]|[1-9]\d))?|([1-9]\d{0,5}\.\d{2}))$
handler: price6pt2
field type: string
Length (property): 9 (to include decimal point '.')

Thanks @g1smd for all the help!

Gez
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!

Please Log in or Create an account to join the conversation.

Last edit: by JoomGuy.

Re: [HOW T0] VALIDATE DECIMAL (MUST BE POSITIVE) 18 Nov 2012 17:28 #5472

  • g1smd
  • g1smd's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • RegEx fiend!
  • Posts: 31
  • Thank you received: 26

audibleid wrote:

^(0(\.(0[1-9]|[1-9]\d))?|([1-9]\d{0,5}\.\d{2}))$
  1. If a user enters .1 it should transform value to 0.10
  2. If a user enters .12 it should transform value to 0.12
These values are allowed/disallowed

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.
Online since 1996.

Please Log in or Create an account to join the conversation.

Re: [HOW T0] VALIDATE DECIMAL (MUST BE POSITIVE) 22 Nov 2012 14:31 #5622

  • JoomGuy
  • JoomGuy's Avatar Topic Author
  • Offline
  • Moderator
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
@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
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!
The following user(s) said Thank You: g1smd

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.061 seconds

WOW.. WOW... WOW... This is awesome... in less than 3 hours of work I have my application done... this is simply the best tool I ever tried to generate Joomla Components... Thank you very much for this tool and your answer.. it helped me a lot... My friends here in Brazil are going nuts with this...
Griiettner (Forum)

Get Started