I have a variable which contains the full file path for a file, example below:
C:\Documents and Settings\leecett\My Documents\output.txt
I want to extract the filename (without the file extension).
Note, the filename may contain other full stops / periods (e.g. output.one.txt), but will always have a file extension of .txt.
So I have a variable:
strFilePath = C:\Documents and Settings\leecett\My Documents\output.one.txt
I want a variable:
strFileName = output.one