Syntax
FILE_NAME(<string>)
Description
Returns only the filename and extension.
Examples
Column1 | FILE_NAME returns |
|---|---|
/dir1/dir2 | dir2 |
/dir1/file.txt | file.txt |
/file.txt | file.txt |
C:\dir1\dir2 | dir2 |
C:\dir1\file.txt | file.txt |
C:\file.txt | file.txt |
/dir1/dir2/ | λ (= an empty string) |
C:\dir1\dir2\ | λ |