trying to cope with awk difficulties

amatuer_lee_3 · #1 (**permalink**) 1 Week Ago

Quote:

echo "Enter month: "

read MONTH

awk '$3=="$MONTH" {print $1, $2, $3, $4, $5, $6}' *.hits

The data we are searching is populated in this way:

----IP---------DAY----MONTH----DATE--------TIME---------YEAR
12.3234.34-----Fri------Nov-------15-------18:05:14 GMT---2008

I want the user to be able to search for the data according to month and year.
However, I cannot quite figure out how to do this. Above is the code i have and i can't understand what is wrong?

If we try and put in the variable e.g Nov, it wont give us any results.

It works only if instead of "$MONTH" we enter the month itself e.g Nov or Sep.

robotronic · #2 (**permalink**) 1 Week Ago

You need to add single quotes to pass inside awk the shell variable:

Code:

awk '$3=='"$MONTH"' {print $1, $2, $3, $4, $5, $6}' *.hits

amatuer_lee_3 · #3 (**permalink**) 1 Week Ago

Quote:

awk '$3=='"$MONTH"' {print $1, $2, $3, $4, $5, $6}' *.hits

I have tried this and it did not work. I also tried:

Quote:

awk '$3=='$MONTH' {print $1, $2, $3, $4, $5, $6}' *.hits

and this also didnt work.

I'm a bit stumped.

Shivdatta · #4 (**permalink**) 1 Week Ago

You need to specify the delimiter used by your flat file in the awk statement..

May not be the case...ignore this

rubin · #5 (**permalink**) 1 Week Ago

You need to use AWK's special way of passing variables into it:

Code:

echo "Enter month: "

read MONTH

awk -v mon="$MONTH"  '$3~mon { print $1, $2, $3, $4, $5, $6}' *.hits

Or equally:

Code:

awk '$3~mon { print $1, $2, $3, $4, $5, $6}'  mon="$MONTH" *.hits

Same thing if year is also needed:

Code:

awk -v mon="$MONTH" -v year="$YEAR" '$3~mon && $6~year { print ... } *.hits

amatuer_lee_3 · #6 (**permalink**) 1 Week Ago

thanks very much.

can you use AWK to search for unique IP's within this?

so if the same IP logged on more than once it would list the one IP with all the hits?

I already have the IP's in a populated file with the month and date.

rubin · #7 (**permalink**) 1 Week Ago

Simply modify the given code:

Code:

echo "Enter month: "

read MONTH

echo "Enter ip: "

read IP


awk -v mon="$MONTH" -v ip="$IP" '$3~mon && $1~ip { print ... }' *.hits

robotronic · #8 (**permalink**) 5 Days Ago

Admitted that rubin's way is much more clearer and readable, you can pass variables also interrupting and resuming the awk code by the means of single quotes, like I posted before.

The problem is that before I made a mistake, you also need to add a couple of double quotes to complicate things a little bit more

Code:

awk '$3=="'"$MONTH"'" {print $1, $2, $3, $4, $5, $6}' *.hits

rubin · #9 (**permalink**) 5 Days Ago

Here goes another unconventional way of passing variables to awk:

Code:

echo "Enter month: "

read MONTH

awk '/'$MONTH'/ { print ... }' file

Caveat emptor:
The above approach does not work if the variable has whitespaces, newlines or certain special characters ( |, /, ...) in it.
So it's always recommended using the conventional way -v var=... .

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Proxy ARP Difficulties	TheMaskedMan	IP Networking	7	11-02-2005 08:14 AM
Simple Network Program Difficulties	Mistwolf	High Level Programming	2	03-19-2002 04:34 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)