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

λ