topic Extracting file attributes from a target database in Qlik Learning Discussions

Extracting file attributes from a target database

Tue, 10 Feb 2015 12:10:28 GMT

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.

Re: Extracting file attributes from a target database

Gysbert_Wassenaar — Tue, 10 Feb 2015 12:32:08 GMT

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 ...