parse_filename()

Returns the last component of the path similarly to Python's os.path.basename function. If trim_extension is true, the file extension will be removed (defaults to false). separator options: system, both_slash (default), forward_slash, backslash.

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

parse_filename(string)

Scalar
Overload link string Returns
#01 VARCHAR VARCHAR

parse_filename(string, separator)

Scalar
Overload link stringseparator Returns
#02 VARCHARVARCHAR VARCHAR

parse_filename(string, trim_extension)

Scalar
Overload link stringtrim_extension Returns
#03 VARCHARBOOLEAN VARCHAR

parse_filename(string, trim_extension, separator)

Scalar
Overload link stringtrim_extensionseparator Returns
#04 VARCHARBOOLEANVARCHAR VARCHAR

Example

parse_filename example
SQL
Haybarn WASM 2.0.0-rc12 Β· In your browser

Engine example Β· Run to view results.