Boolean Initials (T/F, Y/N)

representation.boolean.initials

Boolean value represented as a single initial character: T/F (true/false) or Y/N (yes/no), in any case. Transforms to DuckDB BOOLEAN type.

Domain

representation

Try it

CLI

$ finetype infer -i "T"
→ representation.boolean.initials

DuckDB

Detect

SELECT finetype('T');
-- → 'representation.boolean.initials'

Cast expression

CAST({col} AS BOOLEAN)

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS BOOLEAN) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'representation.boolean.initials';

JSON Schema

finetype schema representation.boolean.initials

{
  "$id": "https://meridian.online/schemas/representation.boolean.initials",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Boolean value represented as a single initial character: T/F (true/false) or Y/N (yes/no), in any case. Transforms to DuckDB BOOLEAN type.",
  "enum": [
    "T",
    "F",
    "t",
    "f",
    "Y",
    "N",
    "y",
    "n"
  ],
  "examples": [
    "T",
    "F",
    "Y",
    "N",
    "t",
    "f",
    "y",
    "n"
  ],
  "title": "Boolean Initials (T/F, Y/N)",
  "type": "string",
  "x-finetype-broad-type": "BOOLEAN",
  "x-finetype-transform": "CAST({col} AS BOOLEAN)"
}

Examples

TFYNtfyn

Aliases

initial_boolchar_bool