Functions/Database & utility/parse_filename
Database & utility Scalar

parse_filename()

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

Arguments & returns

4 overloads

parse_filename(string)

Scalar
Overload link string Returns
#01 VARCHAR VARCHAR

parse_filename(string, trim_extension)

Scalar
Overload link stringtrim_extension Returns
#02 VARCHARBOOLEAN VARCHAR
#03 VARCHARVARCHAR VARCHAR

parse_filename(string, trim_extension, separator)

Scalar
Overload link stringtrim_extensionseparator Returns
#04 VARCHARBOOLEANVARCHAR VARCHAR

Example

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

Engine example · Run to view results.