erickaczmarczyk

combining three fields

Discussion created by erickaczmarczyk on Sep 25, 2012
Latest reply on Sep 25, 2012 by LaRetta

Hi:

 

Currently our inventory in system include 2-3 identifying parts.

 

a prefix, a number, and sometimes a suffix... for example:

 

AB 2489

or

AB 980 22

 

They are broken down into three fields... additionally I have one field that joins these three values together to become:

 

AB.980.22

 

invPre&"."&invNum&"."&invSuff

 

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:

 

AB.2489

 

invPre&"."&invNum

 

thanks.

Outcomes