Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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