Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
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?
Please find the attachment..
hope this helps.
It takes the part of the string starting from the end till the first occurence of the delimiter '\'.