Topic Options
Rate This Topic
#141414 - 08/11/09 02:35 AM Character Validation
Thiyagu Offline
Stealth Member

Registered: 07/03/06
Posts: 13
HI i would like to do character validation for the scenerio

Field should allow only A-F,:,0-9 and also field length should be 39.

I tried with liek ----->field like "[A-F],[A-F][A-F]....up to length 39"
But the problem is if the value less than 39 its failing.
This is also failing field like "[A-F, ],[A-F, ][A-F, ]....up to length 39"

Can any one help me out

Regards
Thiyagu

Top
#141415 - 08/11/09 05:13 AM Re: Character Validation [Re: Thiyagu]
Maggie Offline
Stealth Member
**

Registered: 12/26/07
Posts: 44
Field LIKE [A-F] OR Field LIKE [0-9] OR Field =":" in qual else an error message.Give the Input length as 39 in admin tool Field Properties.

Cheers!!!
_________________________
Maggie

Top
#141416 - 08/11/09 06:06 AM Re: Character Validation [Re: Maggie]
Thiyagu Offline
Stealth Member

Registered: 07/03/06
Posts: 13
Thnx for your reply it will consider only the first letter.
we have to do like

Field like "[A-F][A-F][A-F][A-F][A-F]...39" OR
Field like "[A-F][A-F][A-F][A-F][A-F]...38" OR
Field like "[A-F][A-F][A-F][A-F][A-F]...37" OR
.
.
.
Field like "[A-F][A-F]"
Field like "[A-F]"

I just want to know instead of using like this any short method is there for validating this criteria.
Regards
Thiyagu

Top