MeridianMERIDIAN

UPC

Universal Product Code — 12-digit barcode identifier for retail products. Distinct from EAN-13 (13 digits). Includes a Mod 10 check digit.

UPC

identity.commerce.upc

Universal Product Code — 12-digit barcode identifier for retail products. Distinct from EAN-13 (13 digits). Includes a Mod 10 check digit.

Domain
identity
Category
commerce
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "042100005264"
→ identity.commerce.upc

DuckDB

Detect
SELECT finetype('042100005264');
-- → 'identity.commerce.upc'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.commerce.upc';

JSON Schema

finetype schema identity.commerce.upc
{
  "$id": "https://meridian.online/schemas/identity.commerce.upc",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Universal Product Code — 12-digit barcode identifier for retail products. Distinct from EAN-13 (13 digits). Includes a Mod 10 check digit.",
  "examples": [
    "042100005264",
    "883028594054",
    "012345678905",
    "614141000036"
  ],
  "maxLength": 12,
  "minLength": 12,
  "pattern": "^\\d{12}$",
  "title": "UPC",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

042100005264883028594054012345678905614141000036

Aliases

upc_abarcode

Type Registry