FILE_ROOT

Syntax

FILE_ROOT(<string>)

Description

Returns the root directory of a file path.

Examples

Column1

FILE_ROOT returns

/dir1/dir2

/

/dir1/file.txt

/

C:\dir1\dir2

C:\

C:\dir1\file.txt

C:\

file.txt

λ (= an empty string)