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"



      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"



      Any help would be appreciated.