Currently our inventory in system include 2-3 identifying parts.
a prefix, a number, and sometimes a suffix... for example:
AB 980 22
They are broken down into three fields... additionally I have one field that joins these three values together to become:
My issue is when the suffix value is empty, it places an additional period at the end (AB.2489.)... is there a way to only have the calculation field combine: