Functions/Text & patterns/parse_filename
Text & patterns Scalar

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.

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.