4 Replies Latest reply on Apr 14, 2015 6:36 AM by illbe

    Variable masked serial# question, serial character length varies

    illbe

      Title

      Variable masked serial# question, serial character length varies

      Post

      I have a calculated field that masks the last two numbers of a serial#:

      Let ( serial = Filter ( serial ; "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ; Left ( serial ;4 )  & "xx" )

      My problem is that I need to apply this to a serial field that has variable length serials, I am not sure how to fit this in my calculation.

      Any help is always appreciated.

      Tom