Regular expression to limit number of characters (Text Length) in a field

635
0
03-14-2018 08:52 AM
AhmadSALEH1
Occasional Contributor III

Hello,

I am trying to write a regular expression in table checks that will only allow  10 characters or Less in a field otherwise the value should be reported as an error.

For Example: 

   abcDefghh1 value is ok

   abcDef         value is ok

   abcDefghh1hh  value is not ok 

What I have so far looks like this:

       \a{0,10} or 

 Unfortunately  this is not working since data reviewer doesn't handle {} "Curly brackets" 

so what other  options I might have?  I mean How to set a regular expression that returns the unmatched  values if the characters  exceeded a certain length.

Thank you,

Ahmad 

0 Kudos
0 Replies