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)