topic Re: compare variable to file name without extension and folders in QlikView

compare variable to file name without extension and folders

Tue, 31 Dec 2013 14:15:03 GMT

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?

Thanks,

Boris

Re: compare variable to file name without extension and folders

swuehl — Tue, 31 Dec 2013 14:31:02 GMT

If you have a FILENAME like

c:\Path\Filename.ext

you can extract the Filename like

=subfield(subfield(FILENAME, '\', -1),'.',1)

Or have a look at the system functions, especially FileBaseName()

Re: compare variable to file name without extension and folders

Tue, 31 Dec 2013 14:36:26 GMT

what does -1 in subfield(FILENAME, '\', -1) do?

what will be it's result?

Thanks,

Boris

Re: compare variable to file name without extension and folders

sundarakumar — Tue, 31 Dec 2013 14:40:14 GMT

Please find the attachment..

hope this helps.

-Sundar

Re: compare variable to file name without extension and folders

swuehl — Tue, 31 Dec 2013 14:42:14 GMT

It takes the part of the string starting from the end till the first occurence of the delimiter '\'.