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.
Reference: DuckDB 2.0.0
Arguments & returns
4 overloadsparse_filename(string)
Scalar
| Overload link | string |
Returns |
|---|---|---|
| #01 | VARCHAR |
VARCHAR |
parse_filename(string, separator)
Scalar
| Overload link | string | separator |
Returns |
|---|---|---|---|
| #02 | VARCHAR | VARCHAR |
VARCHAR |
parse_filename(string, trim_extension)
Scalar
| Overload link | string | trim_extension |
Returns |
|---|---|---|---|
| #03 | VARCHAR | BOOLEAN |
VARCHAR |
parse_filename(string, trim_extension, separator)
Scalar
| Overload link | string | trim_extension | separator |
Returns |
|---|---|---|---|---|
| #04 | VARCHAR | BOOLEAN | VARCHAR |
VARCHAR |
Example
Haybarn WASM 2.0.0-rc12 Β· In your browser
Engine example Β· Run to view results.