Variable masked serial# question, serial character length varies
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.