MeridianMERIDIAN

Single Word

representation.text.word

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

Try a value

Single Word's rule accepts it.

Reads it as hello

Use it

Shell
finetype infer -i 'hello' --mode column
# → representation.text.word
DuckDB
SELECT ft_infer('hello');
-- → 'representation.text.word'
Cast template: {col} is your column
LOWER(CAST({col} AS VARCHAR))
Casts to
VARCHAR

Pattern

Length 1 to 100 characters.

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

Similar types

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

In Meridian's datasets

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)

How it's detected

Single word without spaces. Allows hyphens and underscores in middle. Transform lowercases.

Schema

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

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

Type Registry