ISSN

identity.commerce.issn

International Standard Serial Number. 8-digit identifier for periodicals (magazines, journals, newspapers). Format: XXXX-XXXX. Last digit is check character.

Domain

identity

Try it

CLI

$ finetype infer -i "0028-0836"
→ identity.commerce.issn

DuckDB

Detect

SELECT finetype('0028-0836');
-- → 'identity.commerce.issn'

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.issn';

JSON Schema

finetype schema identity.commerce.issn

{
  "$id": "https://meridian.online/schemas/identity.commerce.issn",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "International Standard Serial Number. 8-digit identifier for periodicals (magazines, journals, newspapers). Format: XXXX-XXXX. Last digit is check character.",
  "examples": [
    "0028-0836",
    "1234-567X",
    "0003-7516"
  ],
  "pattern": "^[0-9]{4}-[0-9]{3}[0-9X]$",
  "title": "ISSN",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

0028-08361234-567X0003-7516