Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

Neima

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Subfield should work. What happens if you do a

Load *,

          Subfield(History,chr(10)) as SubHistory,

          index(History,chr(10)),

          index(History,chr(13));

SQL SELECT

          ID,

    History

FROM <TableName>;

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

Subfield should work. What happens if you do a

Load *,

          Subfield(History,chr(10)) as SubHistory,

          index(History,chr(10)),

          index(History,chr(13));

SQL SELECT

          ID,

    History

FROM <TableName>;

HIC

Not applicable
Author

I had only used chr(13).This works.Thanks a lot HIC.Have read many of your blogs.You are an inspiration to newbies like us.Thanks again