How to Calculate Check Digit Combining Multiple Fields?

Koji Mori

• 2023年11月03日 01:15

I have a customer that is requiring to strip the AI (00) from the SSCC barcode.

Normal: "00 1 123456789 1234567 X"

Expected: "1 123456789 1234567 X"

*X=Check Digit

I am creating the SSCC barcode using three named sources as they are generated separately.  

I am able to create the check digit using one of the named sources using VB Script - Multi-Line Script as such: Value = UccMod10(Format.NamedSubStrings("SerialNumber").Value), but do not know how to generate a check digit for all three named sources combined?

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2023年11月03日 09:33

  Depending on where you data is coming from (Data Entry Form or database or fixed) you may need to set the VB to run as an Event Controlled Script that runs at the appropriate time (eg OnSerialise), rather than a Multi-line script as per the image below.

  The simplest way would be to Name all three elements and then concatenate them together in the VB and then apply the check calculation to that string

   

  0
• 

  Koji Mori

  ★ BarTender Hero ★

  • 2023年11月07日 00:55

  Thank you Peter so much, it works beautifully! 

  0

請登入寫評論。