3 Replies Latest reply: Mar 29, 2012 1:56 PM by Don Lee RSS

    importing partial string of data

    Don Lee

      Hello,

       

      I have following informaiton that I need to import from CSV file, mixed with dates and times as below.

       

      5/1/2012 9:00
      5/1/2012 9:00
      5/1/2012 10:30
      5/2/2012 9:30
      5/10/2012 14:00
      5/17/2012 9:00
      5/21/2012 11:00

       

      How can I just import the dates since I cannot use left function...?

      thanks for your help!