Metric Prefix

representation.scientific.metric_prefix

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

Domain

representation

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

Expression

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://meridian.online/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",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "LOWER(CAST({col} AS VARCHAR))"
}

Examples

kilomegamillimicronano

Aliases

si_prefix