Let ( [ serial = Filter ( serial ; "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ;
Ln = Length ( Serial ) - 4 ;
mask = Substitute ( 10^Ln - 1 ; 9 ; "x" )
Left ( serial ;4 ) & mask
I'm sorry Phil I don't think I explained what I'm trying to do very well, my mistake. What I wanted to happen is to mask ONLY the last 2 characters of the serial# but let the rest show i.e. C1999xx or 123445678xx.
I'm sorry I didn't explain that.
Thank you for the above solution as well however :-).
Left ( serial ; Length ( serial ) - 2 ) & "xx"
Phil, thank you again for saving my bacon :-), you're always a huge help, I have learned more about the workings of FM from your answers to my questions than any book could offer.
All the best