topic How to extract data from text file ? in QlikView https://community.qlik.com/t5/QlikView/How-to-extract-data-from-text-file/m-p/299247#M1179910 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How to extrect data from text file which is not arrange in a proper format. Say I want to generate 1 report which contains data like Timestamp, username &amp; document name that user downloaded.</P><P>All these details are present in a text file.</P><P>Br</P><P>Anta</P></BODY></HTML> Mon, 23 Jan 2012 13:50:57 GMT 2012-01-23T13:50:57Z How to extract data from text file ? https://community.qlik.com/t5/QlikView/How-to-extract-data-from-text-file/m-p/299247#M1179910 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How to extrect data from text file which is not arrange in a proper format. Say I want to generate 1 report which contains data like Timestamp, username &amp; document name that user downloaded.</P><P>All these details are present in a text file.</P><P>Br</P><P>Anta</P></BODY></HTML> Mon, 23 Jan 2012 13:50:57 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-text-file/m-p/299247#M1179910 2012-01-23T13:50:57Z How to extract data from text file ? https://community.qlik.com/t5/QlikView/How-to-extract-data-from-text-file/m-p/299248#M1179911 <HTML><HEAD></HEAD><BODY><P>Hi Anta,</P><P></P><P>You will have to use as many string functions as needed to clean the data until you get exactly what you want. As a general rule, I'd load the whole row as one field, and starting from that, cleaning the data as required. You have in <A _jive_internal="true" href="https://community.qlik.com/thread/45077">this thread</A> a good example on how hard could become to do this job in QlikView.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 23 Jan 2012 14:42:13 GMT https://community.qlik.com/t5/QlikView/How-to-extract-data-from-text-file/m-p/299248#M1179911 Miguel_Angel_Baeyens 2012-01-23T14:42:13Z