3 Replies Latest reply: Aug 15, 2014 4:04 AM by Olly Bond RSS

    Identify a section header as a trap?

    Yuriy Bogatyrev

      PRIOR YEAR ADJUSTMENTS Amount Pct to Date Previous Amts Current Amt

      22a 2010 PROP A OBLIGATION 2,901.48 100.00 % 2,901.48 0.00

      22b 2010 DISCRETIONARY PAYMENT 0.69 100.00 % 0.69 0.00

      22a 2011 PROP A OBLIGATION 14,032.70 100.00 % 14,032.70 0.00

      22b 2011 DISCRETIONARY PAYMENT (20.24) 100.00 % (20.24) 0.00

      22a 2012 PROP A OBLIGATION 2,955.53 100.00 % 2,955.53 0.00

      22b 2012 DISCRETIONARY PAYMENT 24.99 100.00 % 24.99 0.00

      22a 2013 PROP A OBLIGATION 18,632.79 100.00 % 18,632.79 0.00

      51c 2013 SPEC ED HEADLEE OBLIGATION 129,891.59 100.00 % 129,891.59 0.00

      22b 2013 DISCRETIONARY PAYMENT 47.68 100.00 % 47.68 0.00

      26a 2013 RENAISSANCE ZONE 9,419.40 100.00 % 9,419.40 0.00

      31d 2013 SCHOOL LUNCH (2,465.95) 100.00 % (2,465.95) 0.00

      $175,420.66 $175,420.66 $0.00

      SUBTOTALS $21,894,407.54 $17,944,205.30 $1,973,774.43

       

      Copy and pasted from a PDF. In bold is the section(column) header and the rest is the data that succeeds it. The issue is there are 5 section headers; Prior year adjustments, Amount, Pct to Date, Previous Amts, Current Amt.  For six columns of data..

      So is there a way for Modeler to trap in order to: 1. detect the header 2. grab the information from the six columns 3. stop when the column reaches a blank.

       

      I am new to Modeler so any help would be greatly appreciated and/or links to resources that provide information on using traps.

      Also, is there a way I can attach the PDF itself to the community forum?

       

      Thanks!