topic importing partial string of data in QlikView https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351250#M1177200 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have following informaiton that I need to import from CSV file, mixed with dates and times as below.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="111"><TBODY><TR><TD align="right" class="xl63" height="20" width="111">5/1/2012 9:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/1/2012 9:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/1/2012 10:30</TD></TR><TR><TD align="right" class="xl63" height="20">5/2/2012 9:30</TD></TR><TR><TD align="right" class="xl63" height="20">5/10/2012 14:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/17/2012 9:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/21/2012 11:00</TD></TR></TBODY></TABLE><P></P><P>How can I just import the dates since I cannot use left function...?</P><P>thanks for your help!</P></BODY></HTML> Tue, 13 Mar 2012 22:15:29 GMT 2012-03-13T22:15:29Z importing partial string of data https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351250#M1177200 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have following informaiton that I need to import from CSV file, mixed with dates and times as below.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="111"><TBODY><TR><TD align="right" class="xl63" height="20" width="111">5/1/2012 9:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/1/2012 9:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/1/2012 10:30</TD></TR><TR><TD align="right" class="xl63" height="20">5/2/2012 9:30</TD></TR><TR><TD align="right" class="xl63" height="20">5/10/2012 14:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/17/2012 9:00</TD></TR><TR><TD align="right" class="xl63" height="20">5/21/2012 11:00</TD></TR></TBODY></TABLE><P></P><P>How can I just import the dates since I cannot use left function...?</P><P>thanks for your help!</P></BODY></HTML> Tue, 13 Mar 2012 22:15:29 GMT https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351250#M1177200 2012-03-13T22:15:29Z importing partial string of data https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351251#M1177201 <HTML><HEAD></HEAD><BODY><P>In your load, use something like</P><P></P><P>LOAD </P><P>...</P><P>Date(Daystart(Timestamp#(YOURFIELD,'D/M/YYYY hh:mm'))) as Date,</P><P>...</P><P>from Table;</P></BODY></HTML> Tue, 13 Mar 2012 22:42:03 GMT https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351251#M1177201 swuehl 2012-03-13T22:42:03Z importing partial string of data https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351252#M1177202 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P style="min-height: 8pt; height: 8pt;">In your load, use this script&nbsp; </P><P>LOAD </P><P>...</P><P>Date(YOURFIELD,'M/DD/YYYY') as Date,</P><P>...</P><P>from Table;</P></BODY></HTML> Wed, 14 Mar 2012 04:48:10 GMT https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351252#M1177202 perumal_41 2012-03-14T04:48:10Z importing partial string of data https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351253#M1177203 <HTML><HEAD></HEAD><BODY><P>Thank you all for your response!</P><P>I know I should've checked but here at my work, it is everyday emergency situation!</P><P></P><P>swuehl, it worked perfect!</P><P></P><P>thank you both again!</P></BODY></HTML> Thu, 29 Mar 2012 17:56:39 GMT https://community.qlik.com/t5/QlikView/importing-partial-string-of-data/m-p/351253#M1177203 2012-03-29T17:56:39Z