Creating a description based on product sku

[ShawnR]

Hi Everyone!

Im looking for help on figuring out a formula that I can use. Maybe some sort of conditional if statement in order to create a 40 character description based on product skus.

Ex:

n-tr-m-blep-4y ---> new Toronto multi option blep 4 year

n=new
tr=Toronto
m=multi option
blep - option choices
4y = 4 year lease

I have multiple cities options so instead of tr it could be van = Vancouver..
I have multiple lease options could be 1 year, 3 year ...
I have option types that could be m=multi or s=single option

I have a column with all the possible unique skus and I need to create a column with a 40 character limit description. How would I aggregate a description in to one cell?

 

[Joe4]

So, do you have some sort of lookup table that lists all the abbreviations and what each stands for?
Where is that table located?