topic Re: File Function Attribute in QlikView https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153992#M376805 <HTML><HEAD></HEAD><BODY><P>Thanks Chanty</P></BODY></HTML> Mon, 04 Jul 2016 04:31:25 GMT Anonymous 2016-07-04T04:31:25Z File Function Attribute https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153990#M376803 <HTML><HEAD></HEAD><BODY><P>I am trying to find what is the use of Attribute (filename, attributename) Function. But I am not getting a clear idea from the Manual.</P><P></P><P>Can some one please explain this function?</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 01 Jul 2016 04:57:51 GMT https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153990#M376803 Anonymous 2016-07-01T04:57:51Z Re: File Function Attribute https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153991#M376804 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><H1><A name="kanchor631"></A>File Functions in Script</H1><P><A name="kanchor632"></A>The file functions (only available in script expressions) return information about the table file which is currently being read. These functions will return NULL for all data sources except table files (Exception: <SPAN class="Bold">ConnectString( )</SPAN>). </P><P>Click on the functions that you would like to know more about:</P><P class="MCDropDown"></P><DIV class="MCDropDownHead_syntax_0"><A class="MCDropDownHotSpot_0" name="attribute"><IMG class="jive-image MCDropDownIcon" style="margin-right: 5px; border-style: none;" /><SPAN class="Bold">Attribute(</SPAN><SPAN class="Italic">filename, attributename</SPAN><SPAN class="Bold">)</SPAN></A> <P></P><P class="MCDropDownBody"></P><P>Returns the value of the meta tags of different file formats, e.g. MP3, WMA, WMV and JPG files, as text. </P><P><SPAN class="Italic">Filename</SPAN> is the name of a media file including path, if needed. </P><P><SPAN class="Italic">Attributename</SPAN> is the name of a meta tag. </P><P>If the file <SPAN class="Italic">filename</SPAN> does not exist, is not a supported file format or does not contain a meta tag named <SPAN class="Italic">attributename</SPAN>, null will be returned. </P><P>A large number of meta tags can be used, e.g. ‘Artist’ or ‘Date Picture Taken’. The supported tags can automatically be generated in the script. The keyboard shortcut for this generation is Ctrl + Q,J,P,G for jpg files (keep the Ctrl key pressed while typing the QJPG combination), Ctrl + Q,M,P,3 for mp3 files and Ctrl + Q,W,M,A for wma files. </P><DIV class="note"><STRONG>Note!</STRONG> <BR />You can only read meta tags saved in the file according to the relevant specification, for example ID2v3 for MP3 files or EXIF for JPG files, not meta information saved in the Windows File Explorer.<P></P><P class="example">Example:</P><P class="Code">Attribute('File', 'Title') as X,</P><P>returns the mp3 tag 'title' in field <SPAN class="Italic">X</SPAN> in each record</P></DIV></DIV></BODY></HTML> Fri, 01 Jul 2016 06:47:58 GMT https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153991#M376804 Chanty4u 2016-07-01T06:47:58Z Re: File Function Attribute https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153992#M376805 <HTML><HEAD></HEAD><BODY><P>Thanks Chanty</P></BODY></HTML> Mon, 04 Jul 2016 04:31:25 GMT https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153992#M376805 Anonymous 2016-07-04T04:31:25Z Re: File Function Attribute https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153993#M376806 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the correct answer with Correct Answer.</P><P>If not, please make clear what part of this topic you still like help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Mon, 04 Jul 2016 06:34:57 GMT https://community.qlik.com/t5/QlikView/File-Function-Attribute/m-p/1153993#M376806 oknotsen 2016-07-04T06:34:57Z