MeridianMERIDIAN

Filename

A bare file name — a stem and a file extension, with no directory separators (report_final.xlsx, IMG_0042.png, archive.tar.gz). The named file entity, distinct from a path (windows_path carries separators), a URL (no scheme/host), a bare word (a real file extension), and the file's properties (representation.file.extension/file_size/mime_type).

Filename

technology.filesystem.filename

A bare file name — a stem and a file extension, with no directory separators (report_final.xlsx, IMG_0042.png, archive.tar.gz). The named file entity, distinct from a path (windows_path carries separators), a URL (no scheme/host), a bare word (a real file extension), and the file's properties (representation.file.extension/file_size/mime_type).

Domain
technology
Category
filesystem
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "report_final.xlsx" --mode column
→ technology.filesystem.filename

DuckDB

Detect
SELECT ft_infer('report_final.xlsx');
-- → 'technology.filesystem.filename'
Cast expression
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) = 'technology.filesystem.filename';

Struct Expansion

Expression
extension: REGEXP_EXTRACT({col}, '\.([^.]+)$')
stem: REGEXP_EXTRACT({col}, '^(.*)\.[^.]+$')

JSON Schema

finetype taxonomy technology.filesystem.filename -o json-schema
{
  "$id": "https://meridian.online/schemas/technology.filesystem.filename",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "A bare file name — a stem and a file extension, with no directory separators (report_final.xlsx, IMG_0042.png, archive.tar.gz). The named file entity, distinct from a path (windows_path carries separators), a URL (no scheme/host), a bare word (a real file extension), and the file's properties (representation.file.extension/file_size/mime_type).",
  "examples": [
    "report_final.xlsx",
    "IMG_0042.png",
    "archive.tar.gz",
    "atarisy2.cpp"
  ],
  "minLength": 3,
  "pattern": "^[^\\\\/\\r\\n\\t]+\\.[A-Za-z0-9]{1,8}$",
  "title": "Filename",
  "type": "string",
  "x-finetype-label": "technology.filesystem.filename",
  "x-finetype-pii": false
}

Examples

report_final.xlsxIMG_0042.pngarchive.tar.gzatarisy2.cpp

Aliases

filenamefile_namefname

Type Registry