identity.person.blood_typeABO blood group system (A, B, AB, O) with optional Rh factor (±). Format: "A+", "B-", "AB", "O+", etc.
$ finetype infer -i "O+"
→ identity.person.blood_typeSELECT finetype('O+');
-- → 'identity.person.blood_type'UPPER(CAST({col} AS VARCHAR))-- 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) = 'identity.person.blood_type';blood_group: REGEXP_EXTRACT(UPPER({col}), '^([ABO]+)')
rh_factor: REGEXP_EXTRACT(UPPER({col}), '([+-])$'){
"$id": "https://meridian.online/schemas/identity.person.blood_type",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "ABO blood group system (A, B, AB, O) with optional Rh factor (±). Format: \"A+\", \"B-\", \"AB\", \"O+\", etc.",
"examples": [
"O+",
"A-",
"AB",
"B+"
],
"pattern": "^(A|B|AB|O)[+-]?$",
"title": "Blood Type",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "UPPER(CAST({col} AS VARCHAR))"
}O+A-ABB+