Functions/Database & utility/parse_dirpath
Database & utility Scalar

parse_dirpath()

Returns the head of the path similarly to Python's os.path.dirname. separator options: system, both_slash (default), forward_slash, backslash

Arguments & returns

2 overloads

parse_dirpath(string)

Scalar
Overload link string Returns
#01 VARCHAR VARCHAR

parse_dirpath(string, separator)

Scalar
Overload link stringseparator Returns
#02 VARCHARVARCHAR VARCHAR

Example

parse_dirpath example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

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