0 Replies Latest reply on Apr 20, 2015 1:06 PM by rufusthedog

    5 Digit Alphanumeric Part Number

    rufusthedog

      Title

      5 Digit Alphanumeric Part Number

      Post

      I'm trying to create a 5 digit alphanumeric part number. This is what I have so far.

      Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36^4)+1;1) &  Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36^3)+1;1) & Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36^2)+1;1) & Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36)+1;1) & Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Mod(id;36)+1;1)

      This seems to work but when the numbers gets higher in value the lower places disappear. For example when  I go past 1295 part number the lowest digit disappears. I know I'm missing something simple but any help would be appreciated.