Ucc Mod 10 Check Digit

Legacy Poster

• December 23, 2013 03:45

Hi,

 

I am new to bartender, how can i create a UCC Mod 10 check digit by excel as my database.

 

For example, Column A is a 17 digit static number

                      Column B is a 12 digit number that needed to be use to calculate the check digit.

 

the final output should look something like this - Column A + Column B +the check digit.

 

Pls help thx :)  

 

0

• 

  Domingo Rodriguez

  Moderator

  ★ BarTender Hero ★

  • December 26, 2013 09:43

  On your BT object you could create 3 data sources. One for "Column A", the second for "Column B" and the third one with a VBScript data type. You would give the second data source (the one for column "B") a variable name, which will then be used by the third data source when you write your VBScript. As an example of the VBScript you could write:

   

  Value = UccMod10 (Format.NamedSubStrings("myvar").Value)

   

  Make sure to give the second data source (for "Column B") a numeric Sample Data.

  0

Please sign in to leave a comment.