FILE_PATH
Syntax
FILE_PATH(<string>)
Description
Returns the file path excluding the root directory and the file name.
Examples
Column1 | FILE_PATH returns |
|---|---|
/dir1/dir2 | dir1/ |
/dir1/file.txt | dir1/ |
/file.txt | λ (= an empty string) |
C:\dir1\dir2 | dir1\ |
C:\dir1\file.txt | dir1\ |
C:\file.txt | λ |
file.txt | λ |