Shell Programming and Scripting

Hello everyone,

By any chance, anyone has a script (shell) that I can modify for the following:

I have daily log files and they look like:

Accept aabbcc [02/Jun/2008:10:34:36 -0600] "111.11.111.111 uid=MyID, ou=People, o=helloworld.com" "webagent" [] []
Reject aabbcc [02/Jun/2008:10:34:36 -0600] "111.11.111.111 uid=MyID, ou=People, o=helloworld.com" "webagent" [] []
Validate ddeeff [02/Jun/2008:10:34:36 -0600] "111.11.111.111 uid=MyID, ou=People, o=helloworld.com" "webagent" [] []


The need is to run a script against it with some inputs, such as:

./script.sh uid start_date end_date all_dates

above may not contain the end_date; but eventually there should be sometimes.

The output should be something like this:

# Total Activities based on uid

uid=aabbcc
Accept: #
Reject: #
Validate: #

uid=ddeeff
Accept: #
Reject: #
Validate: #


so on... If anyone can help, greatly appreciated.

If you get errors use nawk, gawk or /usr/xpg4/bin/awk on Solaris.

Code:

awk '
!($1 in a){a[++i]=$1;a[$1]}
!($2 in b){b[++j]=$2;b[$2]}
END{
  for(k=1;k<=j;k++){
    print "uid=" b[k]
    for(l=1;l<=i;l++){
      print a[l] ": #"
    }
    print ""
  }
}' file

Regards

I appreciate for the response. I tried as you suggested on solaris but getting the error:
i used it as

awk -f a.awk a.txt > a.out

awk: syntax error near line 1
awk: bailing out near line 1

any suggestion please?

thnx much again

As mentioned, on Solaris:

Code:

/usr/xpg4/bin/awk '
!($1 in a){a[++i]=$1;a[$1]}
!($2 in b){b[++j]=$2;b[$2]}
END{
  for(k=1;k<=j;k++){
    print "uid=" b[k]
    for(l=1;l<=i;l++){
      print a[l] ": #"
    }
    print ""
  }
}' file

Regards

I appreciate for very fast response; I had tried the same as code above but it was the same error...I am unsure why it is bailing out at the 1st line...and syntax error..

awk: syntax error near line 1
awk: bailing out near line 1

It works well with the newer versions of awk, I made some changes, give this a try:

Code:

/usr/xpg4/bin/awk '
{if(!($1 in a)){a[++i]=$1;a[$1]}}
{if(!($2 in b)){b[++j]=$2;b[$2]}}
END{
  for(k=1;k<=j;k++){
    print "uid=" b[k]
    for(l=1;l<=i;l++){
      print a[l] ": #"
    }
    print ""
  }
}' file

Hi again, I added the following it works partially what I was looking for:

#!/usr/bin/awk -f
#!/usr/bin/nawk -f
#!/usr/bin/mawk -f
#!/usr/bin/gawk -f

output was:

uid=aabbcc
Accept: #
Reject: #
Validate: #


Is there a way to replace # with number of occurance and is there also a way to print the date stamp in the file below it ?

thanks much once again