Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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