0 Replies Latest reply: Apr 12, 2010 6:19 PM by dgrennie RSS

    How to data load multi line PRN files?

    dgrennie

      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?

      Pxxxxxxxx HEALTH CENTER
      SURGERY DAILY LOG
      FEB 18, 2010 3:51 PM PAGE BREAK B Y DAY (SRGLOG) PAGE 1
      -------- ------------------ --------------- ----------- ------------- ------------------------------- -----------------------------------
      JRNL # PATIENT NAME ANESTHESIA SURGEON STAFF PROCEDURE OR# |- - -T I M E S- - -|
      ACCT #, MR# ASA ANES WC ROOM CUT/CLS ANESDISCHARGE
      SPECIMEN
      OCCURENCE
      -------- ------------------ --------------- ----------- ------------- ------------------------------- -----------------------------------


      SubTotal by PROCDATE: 08/0 1ý09

      /0/1ý/08 Bxxxxxxxx, Kxxxxx TExxxxxxxx xxx G xxxxO H INCISION AND DRAINAGE OF LEFT 1 11:55 12:15 11:55PACU
      4999999999, 799999 1 GEN 4 xxxxx S PERIRECTAL ABSCESS, 12:53 12:40 12:55
      PATH zzzzz C SIGMOIDOSCOPY, BIOPSY OF ------------------
      FISTULA 0:58 0:25 1:00
      682.5
      08/01ý09 Mxxxx, MxxxxxxL xxxxxxx T xxxxxx J Bxxxxxx H EXPLORATION AND REPAIR OF 1 13:19 13:33 13:20PACU
      5100185539, 773944 1 GEN 2 zzzzzzR C xxxxx FRACTURE 14:14 14:09 14:15
      NONE yyyyyyy S ------------------
      0:55 0:36 0:55
      ------------------
      0:44 0:20 0:45

       

      Number o f Records in PROCD ATE Group: 2