Hardware Generation
Type Registry
Hardware Generation
technology.hardware.generation Generation or revision number for hardware (e.g., "Gen 3", "11th Gen", "v2"). Broad categorization.
Domain technology›hardware
Casts to VARCHAR
Scope broad_words
Try it
CLI
$ finetype infer -i "Gen 3"
→ technology.hardware.generation DuckDB
Detect
SELECT finetype('Gen 3');
-- → 'technology.hardware.generation' 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.hardware.generation'; Struct Expansion
generation_number: CAST(REGEXP_EXTRACT({col}, '([0-9]+)') AS SMALLINT) JSON Schema
finetype schema technology.hardware.generation {
"$id": "https://noon.sh/schemas/technology.hardware.generation",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Generation or revision number for hardware (e.g., \"Gen 3\", \"11th Gen\", \"v2\"). Broad categorization.",
"examples": [
"Gen 3",
"11th Gen",
"v2",
"Rev 4"
],
"pattern": "^(?:[0-9]+(?:st|nd|rd|th)\\s+)?(?:Gen|Generation|Rev|Version|v)\\s*[0-9]*$",
"title": "Hardware Generation",
"type": "string"
} Examples
Gen 311th Genv2Rev 4