extract numbers from col/row report 
Author Message
 extract numbers from col/row report

I have these reports I need to extract numbers from and import into excel.
 I am not quite sure where to start but I thought of using a series of if
statements to get to the correct table.

if (m/TEST SUMMARY TABLE/){
   if (m/TEST 2/){

then I will need to grab the 4th percent under TEST 3 (58.9). This is
where I am really drawing a blank and can't figure out how I will get the
number.  Any suggestions?

As an aside I will eventually need to take this number and put it in a
predetermined Excel spreadsheet in col D, row 2.  I know there is an Excel
module but I have never seen or used it. Any suggestions on tutorial,
examples, ...

Lance

TABLE 181
TEST SUMMARY TABLE
Q.DVDTOT

                     TOTAL
                     ACTIV ONLY  RESPS MEMBR MEMBR RESPS MEMBR MEMBR -----
                     ----- ----- ----- ----- ----- ----- -----
                       (A)   (B)   (C)   (D)   (E)   (F)   (G)   (H)

TOC_HYPERLINK
BASE                   483   127   337   258    79*  228   175    53

OVERALL TEST(NET)      337    45   337   258    79   228   175    53
                      69.8  35.4 100.0 100.0 100.0 100.0 100.0 100.0

 TEST 2                228    11   228   175    53   228   175    53
                      47.2   8.7  67.7  67.8  67.1 100.0 100.0 100.0

 TEST 3                188    35   188   152    36   113    88    25
                      38.9  27.6  55.8  58.9  45.6  49.6  50.3  47.2



Sun, 17 Apr 2005 02:22:01 GMT  
 extract numbers from col/row report


Quote:
> I have these reports I need to extract numbers from and import into excel.
>  I am not quite sure where to start but I thought of using a series of if
> statements to get to the correct table.

> if (m/TEST SUMMARY TABLE/){
>    if (m/TEST 2/){

> then I will need to grab the 4th percent under TEST 3 (58.9). This is
> where I am really drawing a blank and can't figure out how I will get the
> number.  Any suggestions?

--snip--

(split)[3];

Split the line on white space then select the fourth element.

Bill



Sun, 17 Apr 2005 04:24:42 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. extract numbers from report-best method?

2. Tk::Table and returning row, col

3. 2 columns, one blank, need to repeat col 1 in col 2

4. Perl line numbers vs Apache error_log reported numbers?

5. extract colum of data from report which has page headers (how can i)

6. Number of Screen Rows

7. Number of rows

8. Counting the number of records in @rows

9. Limitation on number of rows fetched from database ?

10. Oraperl - how to get number of rows without count(*)

11. number of rows in mySQL table

12. DBI::Oracle- Returns wrong number of Rows

 

 
Powered by phpBB® Forum Software