none
Need to append down data on a table RRS feed

  • Question

  • Hi Guys,

    Can someone help . I have a pdf which I converted to txt but the issue is I need to append down data from a different line. See example DPS Regular-Reclaims needs to be populated down beside the two lines below starting with the first column. This is then repeated until it hits the next detail in this case  LTI Regular - Reclaims and so on. Any ideas ? Thanks

    DPS Regular - Reclaims

          Form          Claim                       Item DMA                 Ing.                              Item
       T Number     Number     Claim Date Num. Code    Qty      Cost     Fees      VAT      Total
       - ---------- ---------- --------------- ----- ----- --------- -------- -------- ----------
       4   0000112 xxxx   02/DEC/2016  1  52833    15      1.50     3.50     0.00       5.00
       4   0000291 xxxxx 06/DEC/2016  1  20123   200     82.98     3.50     0.00      86.48

      LTI Regular - Reclaims

          Form          Claim                       Item DMA                 Ing.                              Item
       T Number     Number     Claim Date Num. Code    Qty      Cost     Fees      VAT      Total
       - ---------- ---------- --------------- ----- ----- --------- -------- -------- ----------
       5   0000122 123456  22/MAR/2017  1  17731     5      4.75     3.50     1.90      10.15

    Monday, May 29, 2017 12:02 PM