Solved
Regex
Hi,
I want to use regex function to check if the entered value is a text ( both upper and lower case check) and if it's more than 12 characters.
^[a-zA-Z]{1-12}$" .I used like this. can someone guide here.
stefanhelzle0001Answer
Brainy
July 21, 2023
This is confusing. Why do you check whether the string does NOT match the pattern. I mean, to make sure a string is digits only and max 12 characters, you can use this:
if(
regexmatch(
"^[0-9]{1,12}$",
ri!value,
),
null,
"The account must be numerical and no more than 12 numbers"
)