AnsweredAssumed Answered

Calculation question

Question asked by mjbenun on Jul 12, 2017
Latest reply on Jul 12, 2017 by TomHays

This should be an easy one for many of you- but I'm not sure how to proceed.

 

I have item numbers in my database that are 5-6 numbers followed by two letters- e.g. 685499DG.  I use a calculation to isolate the last 2 letters in a field called BrandCode.

 

Problem is, we just introduced new item numbers that have only 1 letter at the end- eg. 685499R and for those items the Brand code is "R".

 

I need a formula that basically looks for the letters at the end- wether it's 1 letter, 2 letters, etc.

 

Thank you!

Outcomes