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" --mode column
→ representation.text.word

DuckDB

Detect
SELECT ft_infer('hello');
-- → 'representation.text.word'
Cast expression
LOWER(CAST({col} AS VARCHAR))
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'representation.text.word';

JSON Schema

finetype taxonomy representation.text.word -o json-schema
{
  "$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-label": "representation.text.word",
  "x-finetype-pii": false
}

Examples

helloworldhello-worldtest_123

Type Registry