Skip to content

Metric Prefix

Type Registry

Metric Prefix

representation.scientific.metric_prefix

SI metric prefix (kilo, mega, giga, milli, micro, nano, etc.). May include unit or stand alone.

Domain representation›scientific
Casts to VARCHAR
Scope broad_words

Try it

CLI 
$ finetype infer -i "kilo"
→ representation.scientific.metric_prefix

DuckDB

Detect 
SELECT finetype('kilo');
-- → 'representation.scientific.metric_prefix'
Cast expression 
LOWER(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.scientific.metric_prefix';

Struct Expansion

multiplier: CASE WHEN {col} LIKE 'kilo%' THEN 1000 WHEN {col} LIKE 'mega%' THEN 1000000 WHEN {col} LIKE 'giga%' THEN 1000000000 WHEN {col} LIKE 'milli%' THEN 0.001 WHEN {col} LIKE 'micro%' THEN 0.000001 WHEN {col} LIKE 'nano%' THEN 0.000000001 ELSE NULL END
prefix: REGEXP_EXTRACT({col}, '^([a-z]+)')

JSON Schema

finetype schema representation.scientific.metric_prefix 
{
  "$id": "https://noon.sh/schemas/representation.scientific.metric_prefix",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "SI metric prefix (kilo, mega, giga, milli, micro, nano, etc.). May include unit or stand alone.",
  "enum": [
    "yotta",
    "zetta",
    "exa",
    "peta",
    "tera",
    "giga",
    "mega",
    "kilo",
    "hecto",
    "deca",
    "deci",
    "centi",
    "milli",
    "micro",
    "nano",
    "pico",
    "femto",
    "atto",
    "zepto",
    "yocto"
  ],
  "examples": [
    "kilo",
    "mega",
    "milli",
    "micro",
    "nano"
  ],
  "title": "Metric Prefix",
  "type": "string"
}

Examples

kilomegamillimicronano

Also known as

si_prefix

Types in representation