Please assist me. I've recently started coding with Qlikview. I am looking for code to extract file attributes from a target database. I want to extract the file name, path, extension etc. Where can I find such a code?
Something like this:
subfield(MyField, '.', -1) as extension,
mid(MyField, index(MyField, '\',-1)+1, index(MyField,'.',-1)-index(MyField,'\',-1)-1) as file_name,
left(MyField, index(MyField,'\',-1)) as path
Retrieving data ...