topic How to data load multi line PRN files? in QlikView https://community.qlik.com/t5/QlikView/How-to-data-load-multi-line-PRN-files/m-p/250737#M1207428 <HTML><HEAD></HEAD><BODY><P>I have several reports (PRN) that have multiple heading lines and associated detail lines that wrap to the next line. Can I map this into Qlikview and if so, how?</P><P>Pxxxxxxxx HEALTH CENTER<BR /> SURGERY DAILY LOG<BR />FEB 18, 2010 3:51 PM PAGE BREAK B Y DAY (SRGLOG) PAGE 1<BR />-------- ------------------ --------------- ----------- ------------- ------------------------------- -----------------------------------<BR />JRNL # PATIENT NAME ANESTHESIA SURGEON STAFF PROCEDURE OR# |- - -T I M E S- - -|<BR /> ACCT #, MR# ASA ANES WC ROOM CUT/CLS ANESDISCHARGE<BR /> SPECIMEN<BR /> OCCURENCE<BR />-------- ------------------ --------------- ----------- ------------- ------------------------------- -----------------------------------</P><P><BR />SubTotal by PROCDATE: 08/0 1ý09</P><P>/0/1ý/08 Bxxxxxxxx, Kxxxxx TExxxxxxxx xxx G xxxxO H INCISION AND DRAINAGE OF LEFT 1 11:55 12:15 11:55PACU<BR /> 4999999999, 799999 1 GEN 4 xxxxx S PERIRECTAL ABSCESS, 12:53 12:40 12:55<BR /> PATH zzzzz C SIGMOIDOSCOPY, BIOPSY OF ------------------<BR /> FISTULA 0:58 0:25 1:00<BR /> 682.5<BR />08/01ý09 Mxxxx, MxxxxxxL xxxxxxx T xxxxxx J Bxxxxxx H EXPLORATION AND REPAIR OF 1 13:19 13:33 13:20PACU<BR /> 5100185539, 773944 1 GEN 2 zzzzzzR C xxxxx FRACTURE 14:14 14:09 14:15<BR /> NONE yyyyyyy S ------------------<BR /> 0:55 0:36 0:55<BR /> ------------------<BR /> 0:44 0:20 0:45</P><P></P><P>Number o f Records in PROCD ATE Group: 2</P></BODY></HTML> Mon, 12 Apr 2010 22:19:36 GMT 2010-04-12T22:19:36Z How to data load multi line PRN files? https://community.qlik.com/t5/QlikView/How-to-data-load-multi-line-PRN-files/m-p/250737#M1207428 <HTML><HEAD></HEAD><BODY><P>I have several reports (PRN) that have multiple heading lines and associated detail lines that wrap to the next line. Can I map this into Qlikview and if so, how?</P><P>Pxxxxxxxx HEALTH CENTER<BR /> SURGERY DAILY LOG<BR />FEB 18, 2010 3:51 PM PAGE BREAK B Y DAY (SRGLOG) PAGE 1<BR />-------- ------------------ --------------- ----------- ------------- ------------------------------- -----------------------------------<BR />JRNL # PATIENT NAME ANESTHESIA SURGEON STAFF PROCEDURE OR# |- - -T I M E S- - -|<BR /> ACCT #, MR# ASA ANES WC ROOM CUT/CLS ANESDISCHARGE<BR /> SPECIMEN<BR /> OCCURENCE<BR />-------- ------------------ --------------- ----------- ------------- ------------------------------- -----------------------------------</P><P><BR />SubTotal by PROCDATE: 08/0 1ý09</P><P>/0/1ý/08 Bxxxxxxxx, Kxxxxx TExxxxxxxx xxx G xxxxO H INCISION AND DRAINAGE OF LEFT 1 11:55 12:15 11:55PACU<BR /> 4999999999, 799999 1 GEN 4 xxxxx S PERIRECTAL ABSCESS, 12:53 12:40 12:55<BR /> PATH zzzzz C SIGMOIDOSCOPY, BIOPSY OF ------------------<BR /> FISTULA 0:58 0:25 1:00<BR /> 682.5<BR />08/01ý09 Mxxxx, MxxxxxxL xxxxxxx T xxxxxx J Bxxxxxx H EXPLORATION AND REPAIR OF 1 13:19 13:33 13:20PACU<BR /> 5100185539, 773944 1 GEN 2 zzzzzzR C xxxxx FRACTURE 14:14 14:09 14:15<BR /> NONE yyyyyyy S ------------------<BR /> 0:55 0:36 0:55<BR /> ------------------<BR /> 0:44 0:20 0:45</P><P></P><P>Number o f Records in PROCD ATE Group: 2</P></BODY></HTML> Mon, 12 Apr 2010 22:19:36 GMT https://community.qlik.com/t5/QlikView/How-to-data-load-multi-line-PRN-files/m-p/250737#M1207428 2010-04-12T22:19:36Z