3 Replies Latest reply: Aug 11, 2014 12:19 AM by Dean Gwilliam RSS

    extracting multi-line descriptions as single lines

    Dean Gwilliam

      Hi I've managed to extract this from a pdf using monarch pro 8

       

      desc    this    last

      Revenue    494957    339691

      Cost of sales    -242987    -173042

      Gross profit    251970    166649

      Distribution       

      expenses    -68098    -34959

      Administrative       

      expenses    -152673    -115783

      Operating profit    31199    15907

      Share of post tax       

      losses of joint        -3

      venture       

      Finance income        16

      Finance expense    -850    -215

      Profit before tax    30349    15705

      Income tax       

      (expense)/credit    -8070    -4856

      Profit after tax       

      and total       

      comprehensive       

      income    22279    10849

      attributable to       

      owners of the       

      parent       

       

      I'm wondering if I could use monarch to turn the multi-line descriptions into single line ones given that the numbers aren't always on the last line of the description i.e.

      please contrast

       

      Distribution       

      expenses    -68098    -34959

       

      with

       

      Share of post tax       

      losses of joint        -3

      venture   

       

      Also some of the headings start after a blank line but not always,

       

      Also I'd like to tell monarch....only to look x lines down from the sample line

      Btw the numeric fields above are the 3rd and 6th numeric fields.

      As stated you never quite know which of the multi-line description lines they will appear on.

       

      I'd have posted the pdf but couldn't see how

       

      Any help much appreciated