Skip to content

ISSN

Type Registry

ISSN

technology.code.issn

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

Domain technology›code
Casts to VARCHAR
Scope Universal

Try it

CLI 
$ finetype infer -i "0028-0836"
→ technology.code.issn

DuckDB

Detect 
SELECT finetype('0028-0836');
-- → 'technology.code.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) = 'technology.code.issn';

JSON Schema

finetype schema technology.code.issn 
{
  "$id": "https://noon.sh/schemas/technology.code.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"
}

Examples

0028-08361234-567X0003-7516

Types in technology