Solved: Limiting number to certain amount of digits - Page 2

Nick_Neumann · 03-23-2020 10:51 AM

I deal with SKUs that are 7 digits long. the first 6 digits represent the Master SKU and the 7th digit represents a variation of the Master SKU. In my table, sometimes the SKU comes in as 6 digits and sometimes at 7. I would like to create an expression that will delete the last digit of the SKU, ONLY if the SKU is 7 digits long so that way all SKUs in the column are always 6 digits. How would I go about this?

Marc_Dillon

Are you trying to input the expression in the SKU column? That won’t work. You’ll have to create a new column to hold the modified value.

View solution in original post