Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()
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()
what does -1 in subfield(FILENAME, '\', -1) do?
what will be it's result?
Thanks,
Boris
Please find the attachment..
hope this helps.
-Sundar
It takes the part of the string starting from the end till the first occurence of the delimiter '\'.