FILE_BASE

Owned by Charles Bishop (Deactivated)

Jan 30, 2018

1 min read

Syntax

FILE_BASE(<string>)

Description

Returns the non-directory portion of a file path.

Examples

Column1	FILE_BASE returns
/dir1/dir2	dir2
/dir1/file.txt	file
/file.txt	file
C:\dir1\dir2	dir2
C:\dir1\file.txt	file
C:\file.txt	file
file.txt	file
/dir1/dir2/	λ (= an empty string)