Brian Dunning's FileMaker Custom Functions

SSCCChecksum ( SSCCnr )

Creates a checksum for SSCC number

  Average rating: 4.6 (32 votes) Log in to vote

Andy Knasinski   Andy Knasinski
NRG Software, LLC.
http://www.nrgosft.com

Share on Facebook Share on Twitter

  Sample input:
SSCCChecksum ( 0008155380999900001 )
  Sample output:
00081553809999000011

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This script is used to compute a checksum for a given SSCC number. You can also produce a nice text representation using this calc. Works great with Brian Dunning's Code128 solution.

"(" &
Left ( $$sscc ; 2 ) &
") " &
Middle ( $$sscc ; 3; 1 ) &
" " &
Middle ( $$sscc ; 4 ; 7 ) &
" " &
Middle ( $$sscc ; 11 ; 9 ) &
" " &
Right ( $$sscc ; 1 )

 

Comments

H. Lithman   H. Lithman, Sweden
Mar 15, 2011
Hey Andy!

Thanks for a this useful function. I made a little correction, because when the value of checksum gets 10, it should be 0. not 10. Right?

Case ( xDigit = 10 ; xPool & "0" ; xPool & xDigit )
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.