If formula with left retrieval

Question

I am new to Alteryx and I am trying to create a formula which will provide me either the left most 4 or 6 characters of a string based on if they begin with 5050.  If 5050 then return 6 all others will be 4.

16010500000000300     would return 1601

50506000010000001     would return 50506

I appreciate the help.

Thanks

JessieC · Accepted Answer

@cfine

IF Left([Field1], 4)="5050" THEN Left([Field1], 6)
ELSE Left([Field1], 4)
ENDIF

See attached workflow.