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