1 Reply Latest reply on Apr 20, 2017 6:47 PM by Tom W

    If/ Case formula to find alpa/numberic at 5th character

    Ian Barton

      Hi All,

       

      Im trying to create a field that looks at a field - [List], searches for the 5th character and if the character is a number, returns "check" and if its an alpha returns "leave"

       

      EG.

      2001A lorry would be "Check"

      234566 car would be "Leave"

       

      I split the first 5 characters into a [sublist] field and tried this but i keep getting an error and its really inefficient

       

      CASE [sublist]

      WHEN ENDSWITH([sublist], "0") THEN "Check"

      WHEN ENDSWITH([sublist], "1") THEN "Check"

      // continue until 9

      ELSE "Leave"

      END

       

      Any help would be appreciated.

       

      Thanks