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

    Splitting memo field into different lines in qlikview?

      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.