MeridianMERIDIAN

Single Word

representation.text.word

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

Casts to
VARCHAR

Shape

Length 1 to 100 characters.

Pattern
^[a-zA-Z0-9]([a-zA-Z0-9\-_]*[a-zA-Z0-9])?$
ValueLengthShape
hello5matches
world5matches
hello-world11matches
test_1238matches

Told apart

Going the other way, this type's own rule accepts 1 of 8 samples of Entity Name.

Background

Origin

FineType's registry describes a single word as one without spaces, made of letters and digits or joined by common separators such as a hyphen.[1] FineType's definition allows hyphens and underscores only in the middle of the value, so the first and last characters must be letters or digits.[1] FineType's registry notes that the type was called text.word before its v1 migration.[1]

Use

Most programming languages do not allow spaces in names, so a delimiter is needed to mark where each word starts and ends.[2] Some early languages, notably FORTRAN (1955) and ALGOL (1958), allowed spaces within identifiers.[2] Snake case replaces each space with an underscore and writes words in all lower case.[3] The hyphen is commonly used as a word separator when writing COBOL, Forth and Lisp.[2] Hyphen-separated names are also common in Unix for commands and packages, and are used in CSS.[2] C and Pascal-family languages avoided hyphens in names because the hyphen was their subtraction operator.[2]

A value with a space in the middle is not a single word, so a column that mostly fits but has a few spaced values may be free text or a list of names instead. (Meridian's view)

Sources

  1. [1]finetype/labels/definitions_representation.yaml at main · meridian-online/finetype · GitHubFineType
  2. [2]Naming convention (programming) - Wikipediasecondary source
  3. [3]Snake case - Wikipediasecondary source

Detection notes

v1 migration: Was text.word. Single word without spaces. Allows hyphens and underscores in middle. Transform lowercases.

In Meridian's open data

Use it

CLI · DuckDB
$ finetype infer -i "hello" --mode column
→ representation.text.word

SELECT ft_infer('hello');
-- → 'representation.text.word'
Cast expression
LOWER(CAST({col} AS VARCHAR))

Schema

https://meridian.online/schemas/representation.text.word · Frictionless type string

finetype taxonomy representation.text.word -o json-schema

Type Registry