Skip to content

Alphanumeric Identifier

Type Registry

Alphanumeric Identifier

representation.code.alphanumeric_id

Mixed letter-and-digit identifier string that doesn't match a known specific format. Examples: product codes ("SKU-12345"), cabin numbers ("C85"), ticket IDs ("A/5 21171"), lot numbers ("LOT-2024-0042"), license plates ("ABC 1234"). Format-detectable: contains both alphabetic and numeric characters.

Domain representation›code
Casts to VARCHAR
Scope Universal

Try it

CLI 
$ finetype infer -i "SKU-12345"
→ representation.code.alphanumeric_id

DuckDB

Detect 
SELECT finetype('SKU-12345');
-- → 'representation.code.alphanumeric_id'
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) = 'representation.code.alphanumeric_id';

Struct Expansion

alpha_part: REGEXP_EXTRACT({col}, '[A-Za-z]+')
numeric_part: REGEXP_EXTRACT({col}, '[0-9]+')

JSON Schema

finetype schema representation.code.alphanumeric_id 
{
  "$id": "https://noon.sh/schemas/representation.code.alphanumeric_id",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Mixed letter-and-digit identifier string that doesn't match a known specific format. Examples: product codes (\"SKU-12345\"), cabin numbers (\"C85\"), ticket IDs (\"A/5 21171\"), lot numbers (\"LOT-2024-0042\"), license plates (\"ABC 1234\"). Format-detectable: contains both alphabetic and numeric characters.",
  "examples": [
    "SKU-12345",
    "C85",
    "A/5 21171",
    "LOT-2024-0042",
    "ABC 1234",
    "REF-00742",
    "B28",
    "FL-2087"
  ],
  "pattern": "^[A-Za-z][A-Za-z0-9 /_.#-]*[0-9][A-Za-z0-9 /_.#-]*$|^[0-9][A-Za-z0-9 /_.#-]*[A-Za-z][A-Za-z0-9 /_.#-]*$",
  "title": "Alphanumeric Identifier",
  "type": "string"
}

Examples

SKU-12345C85A/5 21171LOT-2024-0042ABC 1234REF-00742B28FL-2087

Also known as

product_codereference_codeticket_idlot_number

Types in representation