representation.text.sentenceGrammatically complete sentence (one or more words, ending with punctuation).
$ finetype infer -i "This is a complete sentence."
→ representation.text.sentenceSELECT finetype('This is a complete sentence.');
-- → 'representation.text.sentence'CAST({col} AS VARCHAR)-- 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.sentence';word_count: CAST(REGEXP_COUNT({col}, '\s+') + 1 AS SMALLINT){
"$id": "https://meridian.online/schemas/representation.text.sentence",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Grammatically complete sentence (one or more words, ending with punctuation).",
"examples": [
"This is a complete sentence.",
"Is this a question?",
"What an exclamation!"
],
"maxLength": 1000,
"minLength": 3,
"pattern": "^[A-Z].*[.!?]$",
"title": "Sentence",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}This is a complete sentence.Is this a question?What an exclamation!