Meridianmeridian

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