Skip to content

Instantly share code, notes, and snippets.

@jeff
Last active November 16, 2021 19:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeff/99e33b24bb369c59e7245ed221ea76b4 to your computer and use it in GitHub Desktop.
Save jeff/99e33b24bb369c59e7245ed221ea76b4 to your computer and use it in GitHub Desktop.
barcode transform table examples
SELECT * FROM config.barcode_transform;
id | active | org_unit | min_length | max_length | required_prefix | pattern | replacement | asset | actor
----+--------+----------+------------+------------+-----------------+---------------+-------------+-------+-------
1 | t | 99 | 8 | 8 | T | ^T0+ | T | t | f
2 | t | 99 | 10 | 10 | 0 | ^0+(\d+)\d{3} | T \1 | t | f
(2 rows)
Rule 1 turns barcodes like T0054321 into T 54321 -- this is a Follet Classic barcode variant, Code 39 symbology
with visible text "T 54321".
Rule 2 turns barcodes like 0012345012 into T 12345 -- this is "Follett Proprietary Interleaved 2 of 5", and
we discard the last three digits rather than attempt to treat them as a check digit and/or Type Indicator. The
visible text may be "T 12345" or "12345".
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment