Hi I would like to now the syntax to compare a variable with a file name , to the actual file name disregarding the path and the extension of the file.
how it is done?
If you have a FILENAME like
you can extract the Filename like
=subfield(subfield(FILENAME, '\', -1),'.',1)
Or have a look at the system functions, especially FileBaseName()
what does -1 in subfield(FILENAME, '\', -1) do?
what will be it's result?
It takes the part of the string starting from the end till the first occurence of the delimiter '\'.
Please find the attachment..
hope this helps.
Retrieving data ...