Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Henric_Cronström
Not applicable

Re: Splitting memo field into different lines in qlikview?

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

2 Replies
Henric_Cronström
Not applicable

Re: Splitting memo field into different lines in qlikview?

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

Re: Splitting memo field into different lines in qlikview?

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