Extracting file attributes from a target database

[#1]

Hi All,

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?

Thanks.

Regards

Ziyanda.

[Gysbert_Wassenaar]

Something like this:

LOAD MyField,

     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

FROM ...