Text & patterns Scalar

parse_dirname()

Returns the top-level directory name from the given path. separator options: system, both_slash (default), forward_slash, backslash.

Arguments & returns

2 overloads

Scalar

Overload link	`path`	Returns
#01	`VARCHAR`	`VARCHAR`

Scalar

Overload link	`path`	`separator`	Returns
#02	`VARCHAR`	`VARCHAR`	`VARCHAR`

SELECT parse_dirname('path/to/file.csv', 'system');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.