Shell Programming and Scripting

hi experts,

i'm new on scripting on solaris 8 sparc, need some advices. i have some data in a file like :

20061221 163826.485 20061221 163925.144 058.659 6123456789012 00000E8A 047 08 002 465 00010022 510105642138069
20061221 163915.163 20061221 163925.336 010.173 6123456789012 00000F4F 037 02 002 999 00010022 510103242202784
20061221 163852.363 20061221 163925.549 033.186 6123456789012 00000EED 040 06 002 999 00010022 510105832049518
20061221 163803.035 20061221 163925.708 082.673 6123456789012 00000E26 010 08 002 800 00010022 510105732551708
20061221 163921.293 20061221 163925.787 004.494 6123456789012 00000F6C 039 02 002 999 00008001 510105642169788
20061221 163650.185 20061221 163926.027 155.842 6123456789012 00000D16 051 08 002 465 00008001 510105732672986
20061221 163923.325 20061221 163926.381 003.056 6123456789012 00000F75 062 02 002 123 00008001 510103342614669

example of the data :

20061221 163923.325 20061221 163926.381 003.056 6123456789012 00000F75 062 02 002 123 00008001 510103342614669

underline is shortcode and bold is causes code

the filename is in date format like "2006122001.TDR" and the file generated each hour like 2006122002.TDR,2006122003.TDR,etc. the file log found at /log/TDR/

i want to check into the file (e.g. 2006122000.TDR) line by line and get how much shortcode having causes code "00008001" and generate it into the the file (e.g. 2006122000.log) each hour and count per shortcode how much each short code having causes code "00008001".

how to create some script to to the task?

please advices...

thank you so much

wu

Code:

awk '$12 == "00008001" { cnt++;cs_cd[$11] } END { print "Count:"cnt;for(cd in cs_cd) print cd }  ' file

Slight amendment to print the count per type

Code:

awk '$12 == "00008001" { 
    cnt++;cs_cd[$11]++ 
} END { 
    printf "Total Count: %s", cnt
    for(cd in cs_cd) {
        printf "%s: %s\n", cd, cs_cd[cd] 
    }
} ' file

hi anbu & reborg,

thank you so much for the help.

how to write to file all line and sorted which having causes code "00008001" and shortcode "..." ?

i mean full line (e.g. 20061221 163921.293 20061221 163925.787 004.494 6123456789012 00000F6C 039 02 002 999 00008001 510105642169788)

thank you so much

please advices


wu

Code:

awk '$12 == "00008001" ' file | sort -t" " -kn11 > newfile

If you want the sorting to be in descending way then

Code:

awk '$12 == "00008001" ' file | sort -t" " -knr11 > newfile

hi anbu,

thank you so much for the help.

fyi, that the log file will logged every hour per day for example : 2006122000.log,2006122001.log,etc

note : 2006122000.log (yyyymmddhh.log)

and will saved in directory like /export/home/log/200612

how to make a script running in background to count how much each shortcode having causes code "00008001" and can logged it the info into file.txt ?

note :the script can read the log file each hour and count it

please advices


thank you so much


wu

use & to run the command in background like :-

temp.sh &