Skip to main content

How to create syntax check only for digits (0-9) and letters (A-Z)?

  • December 5, 2023
  • 2 replies
  • 0 views

Forum|alt.badge.img

Hi, I need to create syntax check that will allow to enter values consisting of digits and letters only (no sign etc)

Example: A1A1A or 1A1A1 (so it can be mix of digits and letters only without any particular sequence). And no sign allowed like: /, *, _, % etc. 

How should the ENT((X)) in field syntax property look like? 

Best Regards,

Jozef



------------------------------
Jozef Prokopovic
Uniface Community Edition Shared Account
US
------------------------------

2 replies

Gianni Sandigliano
Forum|alt.badge.img

Hi, I need to create syntax check that will allow to enter values consisting of digits and letters only (no sign etc)

Example: A1A1A or 1A1A1 (so it can be mix of digits and letters only without any particular sequence). And no sign allowed like: /, *, _, % etc. 

How should the ENT((X)) in field syntax property look like? 

Best Regards,

Jozef



------------------------------
Jozef Prokopovic
Uniface Community Edition Shared Account
US
------------------------------

Hi Jozef,

Quick response: without reading (again) documentation and testing it I would give a try to "#*&*#*"...

Gianni



------------------------------
Gianni Sandigliano
IT
------------------------------

Gianni Sandigliano
Forum|alt.badge.img

Hi Jozef,

Quick response: without reading (again) documentation and testing it I would give a try to "#*&*#*"...

Gianni



------------------------------
Gianni Sandigliano
IT
------------------------------

Hi Josef

The solution I proposed works only partially...

AFAIK the only real solution is:
- ENT(@*)
Accepting digit + alpha + underscore then check for underscore in the VALIDATE FIELD. It can be defined at model level.

Regards,
Gianni



------------------------------
Gianni Sandigliano
IT
------------------------------