How to extract data from barcodes using Orca Variables

Orca Variables make it easy to extract a specific value from a barcode and move it to another field. Simply add an Orca Variable as a default value to one of your fields and scan a barcode.

GS1

You can extract GS1 values from a GS1 barcode using the following variables:

Orca Variable GS1 AI Description
$GS1:ISVALID - True if barcode is a valid GS1
$GS1:SSCC 00 Serial Shipping Container Code
$GS1:GTIN 01 Global Trade Item Number
$GS1:CONTENT 02 GTIN of contained trade items
$GS1:LOT 10 Batch or lot number
$GS1:MANUFACTUREDATE 11 Production date
$GS1:DUEDATE 12 Due date
$GS1:PACKINGDATE 13 Packaging date
$GS1:BESTBEFOREDATE 15 Best before date
$GS1:SELLBYDATE 16 Sell-by date
$GS1:EXPIRYDATE 17 Expiration date
$GS1:SERIAL 21 Serial number
$GS1:CPV 22 Consumer product variant
$GS1:3340 3340 Area in square metres
$GS1:GLN 414 Global location number
$GS1:GSRN 8018 Global Service Relation Number

Extract the full range of GS1 Application Identifiers using $GS1: followed by the relevant AI (example $GS1:3340)

HIBC

You can extract HIBCC (Health Industry Business Communications Council) values from a HIBC barcode using the following variables:

Orca Variable Description
$HIBC:CHECK Check character
$HIBC:EXPIRYDATE Expiry Date
$HIBC:ISCONCATENATED True if barcode is Concatenated HIBC
$HIBC:ISPRIMARY True if barcode is Primary HIBC
$HIBC:ISSECONDARY True if barcode is Secondary HIBC
$HIBC:ISVALID True if barcode is a valid HIBC
$HIBC:LIC Labeler Identification Code
$HIBC:LOT Lot number
$HIBC:PCN Product or Catalog Number
$HIBC:QUANTITY Quantity
$HIBC:UOM Unit Of Measure

ISBT

You can extract ICCBBA (International Council for Commonality in Blood Banking Automation) values from an ISBT barcode using the following variables:

Orca Variable Description
$ISBT:DI Device Identifier for Blood Container
$ISBT:DIN Donation Identification Number
$ISBT:EXPIRYDATE Expiration Date
$ISBT:ISVALID True if barcode is a valid ISBT
$ISBT:LOT Lot Number
$ISBT:MANUFACTUREDATE Manufacturing Date
$ISBT:SERIAL Serial Number

UDI

You can extract UDI (Unique Device Identification) values from a UDI barcode using the following variables (supports GS1, HIBCC and ICCBBA standards):

Orca Variable Description
$UDI:DI Device Identifier (GTIN, PCN)
$UDI:EXPIRYDATE Expiration Date
$UDI:ISVALID True if barcode is a valid UDI
$UDI:LOT Lot Number
$UDI:PRODDATE Production/Manufacture Date
$UDI:SERIAL Serial Number
$UDI:TYPE Data structure GS1, HIBC or ISBT

The UDI variables allow you to scan and extract data form any UDI barcode (GS1, HIBCC, ICCBBA) regardless of the issuing agency.

JSON

To extract data from a JSON object embedded in a barcode, use the following:

Orca Variable Description
$JSON:ISVALID True if barcode is a valid JSON object
$JSON:KEY Value of JSON property if it exists

Formatting values

Append a third segment to any Orca Variable to format the output.

Dates

If the value of the variable is a date, you can use any combination of the following suffixes to change the date format (e.g. $GS1:EXPIRYDATE:DDMMYY returns Day, Month and Year).

Suffix Description Example
CC 2 digit century 20
D 1 digit day 2
DD 2 digit day 02
DDD 3 character day name Sat
DDDD Full day name Saturday
H 1 digit hour 3
HH 2 digit hour 03
m 1 digit minute 3
M 1 digit month 3
MM 2 digit month 03
mm 2 digit minute 02
MMM 3 character month name Jan, Feb
MMMM Full month name January, February
YY 2 digit year 19
YYY 3 digit year 019
YYYY 4 digit year 2019

Characters

Get only a specific number of characters using the new JAX (Just An X) syntax:

Suffix Description
A alpha character (case insensitive)
EX Exclude a number of characters
FIRST Take the number of characters from the left
LAST Take the number of characters from the right
N numeric digit
X alphanumeric character (inc space and -)

Each suffix must be followed with the number of characters you want to capture (e.g. X6 returns Orca S from Orca Scan):

Example Description
A..3 0 to 3 alpha characters
A3 3 alpha characters
EX-3 Exclude the last 3 characters
EX3 Exclude the first 3 characters
FIRST3 First 3 characters
LAST3 Last 3 characters
N..3 0 to 3 numeric digits
N3 3 numeric digits, predefined length
X..3 0 to 3 alphanumeric characters
X3 3 characters, fixed-length

As with everything in Orca Scan, variables will evolve based on your feedback. So let us know what you’d like to see next.

Ready to start scanning?