MeridianMERIDIAN

Windows File Path

An absolute Microsoft Windows filesystem path: a drive letter and colon (C:\, D:\) or a UNC share root (\\server\share) followed by backslash-separated segments. Distinct from URLs (no scheme) and POSIX paths (forward-slash rooted).

Windows File Path

technology.filesystem.windows_path

An absolute Microsoft Windows filesystem path: a drive letter and colon (C:\, D:\) or a UNC share root (\\server\share) followed by backslash-separated segments. Distinct from URLs (no scheme) and POSIX paths (forward-slash rooted).

Domain
technology
Category
filesystem
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "C:\Windows\System32\drivers\WdfLdr.sys" --mode column
→ technology.filesystem.windows_path

DuckDB

Detect
SELECT ft_infer('C:\Windows\System32\drivers\WdfLdr.sys');
-- → 'technology.filesystem.windows_path'
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.windows_path';

Struct Expansion

Expression
drive: REGEXP_EXTRACT({col}, '^([A-Za-z]:)')
filename: REGEXP_EXTRACT({col}, '([^\\]+)$')

JSON Schema

finetype taxonomy technology.filesystem.windows_path -o json-schema
{
  "$id": "https://meridian.online/schemas/technology.filesystem.windows_path",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "An absolute Microsoft Windows filesystem path: a drive letter and colon (C:\\, D:\\) or a UNC share root (\\\\server\\share) followed by backslash-separated segments. Distinct from URLs (no scheme) and POSIX paths (forward-slash rooted).",
  "examples": [
    "C:\\Windows\\System32\\drivers\\WdfLdr.sys",
    "D:\\research\\repos\\project\\src\\Main.cs",
    "\\\\server\\share\\reports\\q3.xlsx"
  ],
  "minLength": 3,
  "pattern": "^([A-Za-z]:\\\\|\\\\\\\\)[^\\r\\n]*$",
  "title": "Windows File Path",
  "type": "string",
  "x-finetype-label": "technology.filesystem.windows_path",
  "x-finetype-pii": false
}

Examples

C:\Windows\System32\drivers\WdfLdr.sysD:\research\repos\project\src\Main.cs\\server\share\reports\q3.xlsx

Aliases

pathfilepathdirectory

Type Registry