How can I do a regex match with an IF THEN Statement where anything after the string is matched.
I.e. anything after X in ""ND.X" is matched and equal to 1.
Trying to apply that to my other strings as well in this formula below.
IF [TRIMPROGRAM]="AUTH.AUT" or [TRIMPROGRAM]="AUTH.ASD.ZY" or [TRIMPROGRAM]="CRED.CTEL.ZY" or [TRIMPROGRAM]="CRED.CTEL" or [TRIMPROGRAM]="CRED.XA2" or [TRIMPROGRAM]="CRED.XA2.ZY" or [TRIMPROGRAM]="ND.X" THEN 1 ELSE 0 ENDIF
Attached is my workflow. Essentially, I am trying to make the new column equal to 1 based on a condition. I have many ND.X's so was wondering if there was a regex formula I can use where it catches anything after the X in ND.X
Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.
Quite hard to understand your issue...
Attached a workflow and updated post