AnsweredAssumed Answered

Variable masked serial# question, serial character length varies

Question asked by illbe on Apr 13, 2015
Latest reply on Apr 14, 2015 by 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

Outcomes