Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: need help with gawk script
Top Forums Programming need help with gawk script Post 302478372 by gengar on Tuesday 7th of December 2010 07:34:28 PM
Old 12-07-2010
thanks I kinda figured it out, it wasn't the perfect way but it worked. heres the code in case anyone needs it in the future.



Code:
let arg=$1
gawk < file '{{
        if ($3 <= '$arg')
{
set=2010
avg=($4/(set-$3))

printf "*%-10s %-8s   %2d   %5d    $ %8.2f", $1, $2, $3, $4, $5, $6
print  "  "avg
}
 else
 {
set=2010
avg=($4/(set-$3))

 printf "%-10s %-8s   %2d   %5d    $ %8.2f", $1, $2, $3, $4, $5, $6
print  "  "avg
}}

}'

I probably would like to make it look cleaner if anyone knew how to put the avg into the printf fields. Thank you guys
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to use variables and gawk in a script?

Hi, I want to define variables in a shell script and make gawk use them to make some operations Mfn = $(grep " 1 " $fitxer | gawk '{print $2}') Xfn = $(grep " 1 " $fitxer | gawk '{print $3}') Yfn = $(grep " 1 " $fitxer | gawk '{print $4}') Zfn = $(grep " 1 " $fitxer | gawk... (9 Replies)
Discussion started by: pau
9 Replies

2. UNIX for Dummies Questions & Answers

Calculating field using AWK, or GAWK script

Hello all, I'm totally new to UNIX/Linux but I'm taking a course in it at my local JC. My question: I have been tasked with writing a gawk script that will create a nicely formatted report. That part I've done ok on...however, the very last thing that must be done is a calculation of a... (4 Replies)
Discussion started by: Trellot
4 Replies

3. Shell Programming and Scripting

gawk script

Hey guys need your help with an gawk script... here's what I have so far gawk '^d/ {printf "%-20s %-10s %-10s %-10s %-4s%2s %5s\n",$9,$1,$3,$4,$6,$7,$8}' ls.kbr The file ls.kbr is a capture of 'ls-al' What I want gawk to do is: 1) Find only directories (this is working) 2) skip lines... (2 Replies)
Discussion started by: zoo591
2 Replies

4. Shell Programming and Scripting

Issues with filtering duplicate records using gawk script

Hi All, I have huge trade file with milions of trades.I need to remove duplicate records (e.g I have following records) 30/10/2009,trdeId1,..,.. 26/10/2009.tradeId1,..,..,, 30/10/2009,tradeId2,.. In the above case i need to filter duplicate recods and I should get following output.... (2 Replies)
Discussion started by: nmumbarkar
2 Replies

5. Shell Programming and Scripting

Help with gawk script that aggregates ip address ranges

Howdy folks, perhaps someone can help me with this problem. My knowledge of awk is not the best... but I've managed to a certain degree and now I'm stuck. These are the steps and the format outputs, problem is written in red text after the STEP 2: STEP 1 Unformated text file (100+... (3 Replies)
Discussion started by: gustisok
3 Replies

6. Windows & DOS: Issues & Discussions

Gawk Script in Windows batch file - Help

Good morning all. I have been running into a problem running a simple gawk script that selects every third line from an input file and writes it to an output file. gawk "NR%3==0" FileIn > FileOut I am attempting to run this command from a batch file at the command line. I have several hundred... (6 Replies)
Discussion started by: 10000springs
6 Replies

7. Shell Programming and Scripting

Help with gawk array, loop in tcsh script

Hi, I'm trying to break a large csv file into smaller files and use unique values for the file names. The shell script i'm using is tcsh and i'm after a gawk one-liner to get the desired outcome. To keep things simple I have the following example with the desired output. fruitlist.csv apples... (6 Replies)
Discussion started by: theflamingmoe
6 Replies

8. Shell Programming and Scripting

gawk script to search and replace text in a flat file

Hi I am new to unix and newbie to this forum. I need help in writing a gawk script that search and replace particular text in a flat file. Input file text : ZIDE_CONTROL000 100000000003869920900000300000001ISYNC 000002225489 0000000002232122 20120321 16:40:53 ZIDE_RECORD000... (5 Replies)
Discussion started by: gkausmel
5 Replies

9. Shell Programming and Scripting

[BASH] Gawk + MYSQL script

Hello! I've got script to write. It should read databases (names, volumes) from table testdatabase and compares it to actually existing databases in /var/lib/mysql/. If there is no informations about database in table - we should see information "There is no declared informations about database... (1 Reply)
Discussion started by: Zimny
1 Replies

10. Shell Programming and Scripting

Gawk program not working in a script

I've written a very simple gawk program which runs when I execute it at the POSIX shell but the corresponding '.awk' script I wrote doesn't return any data. I'm on an HP-UX running gawk version 3.1. (w/all the defaults) (As you can probably guess I'm a newbie going through the manual and trying... (2 Replies)
Discussion started by: RUCerius
2 Replies

LEARN ABOUT DEBIAN

ns_sockcloselater

Ns_Sock(3aolserver)					   AOLserver Library Procedures 				       Ns_Sock(3aolserver)

__________________________________________________________________________________________________________________________________________________

NAME

       Ns_BindSock,  Ns_GetSockAddr,  Ns_SockAccept,  Ns_SockAsyncConnect,  Ns_SockAsyncConnect2,  Ns_SockBind, Ns_SockCloseLater, Ns_SockConnect,
       Ns_SockConnect2, Ns_SockListen, Ns_SockListenEx, Ns_SockPipe, Ns_SockSetBlocking, Ns_SockSetNonBlocking, Ns_SockStrError,  Ns_SockTimedCon-
       nect, Ns_SockTimedConnect2, ns_pipe, ns_sockpair - library procedures

SYNOPSIS

       #include "ns.h"

       Ns_BindSock(arg, arg)

       Ns_GetSockAddr(arg, arg)

       Ns_SockAccept(arg, arg)

       Ns_SockAsyncConnect(arg, arg)

       Ns_SockAsyncConnect2(arg, arg)

       Ns_SockBind(arg, arg)

       Ns_SockCloseLater(arg, arg)

       Ns_SockConnect(arg, arg)

       Ns_SockConnect2(arg, arg)

       Ns_SockListen(arg, arg)

       Ns_SockListenEx(arg, arg)

       Ns_SockPipe(arg, arg)

       Ns_SockSetBlocking(arg, arg)

       Ns_SockSetNonBlocking(arg, arg)

       Ns_SockStrError(arg, arg)

       Ns_SockTimedConnect(arg, arg)

       Ns_SockTimedConnect2(arg, arg)

       ns_pipe(arg, arg)

       ns_sockpair(arg, arg)
_________________________________________________________________

DESCRIPTION

       These functions ...

SEE ALSO

       nsd(1), info(n)

KEYWORDS

AOLserver								4.0						       Ns_Sock(3aolserver)
All times are GMT -4. The time now is 01:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy