Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6864 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Case(Length(text) > 6 ; "Valid" ; "Invalid" )

As for the alphanumeric thing, you could do a substitute of all 26 characters and 9 numbers and if the result is an empty string, it's valid, otherwise its invalid.

i.e.

If(Length(text) > 5 and

IsEmpty(

Substitute(text ;

[ "a" ; "" ] ;

[ "b" ; "" ] ;

[ "c" ; "" ] ;

.......

[ "9" ; "" ] ;

[ "0" ; "" ])

)

; "Valid" ; "InValid" )

~Genx

Posted

P.s. im not sure if subsitute function is case sensitive, but if it is, you'll be doing that for 52 letters

~Genx

This topic is 6864 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.