We have ExtractFileExt which let us know the specific file's extension.
We have ExtractFilePath which let us know the specific file's path.
We have ExtractFileName which let us know the specific file's name+file extension.
Thus I need to trim etc. the file name in order to just convert a XLSX file to XLS. By my suggestion we would have a switch that will tell the script if file extension is wanted or not.
Let>FILENAME_EXT=0
This will trim the file extension.
Let>FILENAME_EXT=1
(DEFAULT) Will include the file extension.
Hope it make sense.
PS, I do this now with RegEx but it's not that logic for the untrained eye.
Code: Select all
ExtractFileName>%CURRENT_FILE%,strFileName
RegEx>\.[^.]*$,strFileName,0,Arr,Num,1,,strFileName