Last active
November 16, 2021 19:25
-
-
Save jeff/99e33b24bb369c59e7245ed221ea76b4 to your computer and use it in GitHub Desktop.
barcode transform table examples
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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