Can I get awk to do this?

jspaceman · 02-13-2009, 10:01 PM

I have a text file (see below) that I want to perform some simple addition on. I want to take the number in the "CUM.RE.WORTH" column (19.3000), add it to the number in the "RE.WORTH" column, and put the result on the next line of the "CUM.RE.WORTH" column. I know how to get awk to read specific columns, but I'm not sure how to get it to start reading a column at a specific line, or append data to a specific column, etc.

Would awk be a good tool for this, or should I use something else?

Code:

              REACTIVITY EFFECTS OF LOADING CHANGES
 
 
   DATE OF SHUTDOWN : 2009-02-08
 
==========================================================================
| SITE    |   TYPE OF LOADING              |   RE.WORTH   | CUM.RE.WORTH |
|         |                                |    ( mk )    |     ( mk )   |
==========================================================================
                  REACTIVITY AT S/D                              19.3000
   
   M19            MRZ469                OUT        -1.0000
   M19            MRR401                IN          1.0000
   M13            MRL474                OUT        -1.0000
   M13            MRX402                IN          1.0000
   L22            MRG475                OUT        -1.0000
   L22            MRJ403                IN          1.0000
   M17            URR8553-4             OUT         0.8000
   M17            URR8573-4             IN         -0.8000
   L18            MRM477                OUT        -1.0000
   L18            MRS404                IN          1.0000
   M15            MRV478                OUT        -1.0000
   M15            MRW405                IN          1.0000
   L08            S340B267              OUT        -7.3000
   L28            FL1608                OUT        -2.5000
   L28            FL1580                IN          4.2000
   M17            DMY-5                 OUT         0.2000
   K15            URR8570-6             OUT         0.8000
   K15            DMY-5                 IN         -0.2000
   M17            URR8570-5             IN         -0.8000
   L08            HFD3B                 IN          2.0000
   B11            FL1633                OUT        -3.2000
   B11            FLNEW                 IN          4.4000
   L04            FL1564                OUT        -1.4000
   L04            FL1633                IN          4.9000
   K17            FL1605                OUT        -4.1000
   K17            FL1599                IN          5.9000

anomie · 02-13-2009, 10:04 PM

(I think) I see what you're asking. You want to have a running total on the far right column? How about posting what you've tried so far?

To answer your more general question, you could probably kludge together an awk script to handle this problem. (i.e. I don't think it's beyond awk's capabilities.)

paulsm4 · 02-14-2009, 02:35 AM

Awk can do it ...

... but Perl would probably be a much easier

IMHO .. PSM

colucix · 02-14-2009, 02:59 AM

Code:

/CUM.RE.WORTH/ {
    print ; getline
    print ; getline
    print ; getline
    num = $NF
}

/\yOUT\y|\yIN\y/ {
    head = substr($0,1,50)
    sum = $NF + num
    gsub($0,sprintf("%s %8.4f", head, sum))
}
    
{ print }

ghostdog74 · 02-14-2009, 08:07 AM

Code:

awk '/REACTIVITY AT S\/D/{n=$NF}$3~/IN|OUT/{$NF=$NF+n}1' file

colucix · 02-14-2009, 09:57 AM

ghostdog74, this time your incredibly short one-liner does not preserve spacing in lines containing IN/OUT. colucix b. ghostdog 2-1

ghostdog74 · 02-14-2009, 11:30 PM

Quote:

Originally Posted by colucix

ghostdog74, this time your incredibly short one-liner does not preserve spacing in lines containing IN/OUT. colucix b. ghostdog 2-1

lol. i leave it to the OP then..