FILE_NAME

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\

λ