Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Transforming

Suryachoppakatla
7 - Meteor

Hello Experts,

 

I need a help with regard to achiever "Valid or Invalid" result

 

Filers GIIN field is a combination of "Alpha + Numeric + Special character" like the one shown below and it should be (19 character length)

 

1CSJ3C.99999.SL.136

 

I wanted to write a formula where if there is any change in this format then should result as "Invalid" Else "Valid". IMP NOTE: This format is case sensitive

 

I tried "Length" formula, but do not meet the purpose of this specific format

 

Regards,

Surya

 

1 REPLY 1
MilindG
12 - Quasar