2 Replies Latest reply: Feb 28, 2013 7:06 AM by Naima Mohammed RSS

    Splitting memo field into different lines in qlikview?

    Naima Mohammed

      Hi all,

       

      I have the following fields in my database:

       

       

      ID                                                       History (memo datatype in access db)

      4320400002/01/2006 09:05 J1  Inquiry Received
      12/01/2006 13:13 J1  Pricing Completed
      12/01/2006 13:13 J1  Quotation Produced - Ref XXXXX
      4320500002/01/2006 09:07 J1  Inquiry Received
      07/01/2006 10:28 J1  Pricing Completed
      07/01/2006 10:29 J1  Quotation Produced - Ref XXXXXX
      05/02/2006 18:19 SU  Order Received
      06/03/2006 09:38 JL  Shipment Recorded #12470

       

      I want to extract the dates for each status of order in the History for every ID on load.

       

      I tired a lot to split using trim, subfield and  chr(13) but it doesnot seem to work.

       

      It would be great if anyone could help me out.Thanks a lot in advance.

      Neima