Database & utility Scalar

parse_path()

Returns a list of the components (directories and filename) in the path similarly to Python's pathlib.PurePath::parts. separator options: system, both_slash (default), forward_slash, backslash

Arguments & returns

2 overloads

`parse_path(string)`

Scalar

Overload link	`string`	Returns
#01	`VARCHAR`	`VARCHAR[]`

`parse_path(string, separator)`

Scalar

Overload link	`string`	`separator`	Returns
#02	`VARCHAR`	`VARCHAR`	`VARCHAR[]`

Example

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3