This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i want to obtain a substring (last part) of a string, because i've a path conteining a file name and i have to retrieve only the file name.
The work case is the following:
PATH FOLDER: C:\Users\thom.yorke\Desktop\Samples\
NAME TO RETRIEVE: file1
Is there a method to subtract PATH FOLDER to string PATH?
You could use:
subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1) to get the filename with extension and another subfield() could also split them like:
subfield(subfield('C:\Users\thom.yorke\Desktop\Samples\file1.doc', '\', -1), '.', 1)
If it should happens within a load you could also use filebasename().
View solution in original post
Ok, it works fine!
Thank You a lot