Discussion Board for collaboration related to QlikView App Development.
I have data something like below, and i need to remove last folder/filename from the path and create a new field.
Can anyone help me what functions i need to use here... path depth is not constant here.
Left(fieldname, Index(fieldname, '\', -1) - 1) as RemainingPath,
Index with a -ve start searches backwards from the end of the string.
View solution in original post
Thank you, actually it is giving result of last folder.
But i would like to create a new field where it exclude last folder and gives remaining path.
As you want to remove, it would be better to do so: