Skip to main content

FILENAMEWITHOUTEXTENSION

Returns the file name without extension as a string.

info

Remember to escape the backslashes in your file path, otherwise your expression will error.

Syntax

string FILENAMEWITHOUTEXTENSION(string fileName)

Example

FILENAMEWITHOUTEXTENSION("C:\\mydir\\myfile.ext")

or

FILENAMEWITHOUTEXTENSION("myfile.ext")

Will return 'myfile'.


You can pass the column name that contains the file path into the function instead of having a hard coded path.

For example:

FILENAMEWITHOUTEXTENSION(FilePath)