MeridianMERIDIAN

Single Word

Single word without spaces (alphanumeric or with common separators like hyphen).

Single Word

representation.text.word

Single word without spaces (alphanumeric or with common separators like hyphen).

Domain
representation
Category
text
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "hello"
→ representation.text.word

DuckDB

Detect
SELECT finetype('hello');
-- → 'representation.text.word'
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.text.word';

JSON Schema

finetype schema representation.text.word
{
  "$id": "https://meridian.online/schemas/representation.text.word",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Single word without spaces (alphanumeric or with common separators like hyphen).",
  "examples": [
    "hello",
    "world",
    "hello-world",
    "test_123"
  ],
  "maxLength": 100,
  "minLength": 1,
  "pattern": "^[a-zA-Z0-9]([a-zA-Z0-9\\-_]*[a-zA-Z0-9])?$",
  "title": "Single Word",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "LOWER(CAST({col} AS VARCHAR))"
}

Examples

helloworldhello-worldtest_123

Type Registry