getdpg
January 16, 2006, 12:17pm
1
Dear All ,
I am learning Unix and i need help to extract specific data from file .
I want to grep number of fails from log . The file contains "fails" word in line if test cases are failed .
The log contains results for different version . i want to count total number of fails on different version .
The log contains more than 1000 lines and searching fails is very difficult for me .
Example-
please help me to write shell scripting
regards
#!/usr/bin/ksh
IFS="
for name in $(grep fails tmp1 | cut -d"-" -f1 | sort -u)
getdpg
January 16, 2006, 1:09pm
3
it is giving me error . Please help me and write full shell script with example
That is complete script, you just need to creat a file with tmp1 contains the data... or have whatever file name you want.
#!/usr/bin/ksh
IFS="
for name in $(grep fails <filename> | cut -d"-" -f1 | sort -u)
Replace <filename> with the actual file name.
Also please post the error message when you get any error, otherwise we would not be able to help without knowing the error.
getdpg
January 16, 2006, 9:10pm
5
getting error as syntax error at line no 5 : $ unexpected ..
pls help me . ..
Onemorething i have several files . i dont want to hardcord in shell script
please give me soultion
just would like to clarify if the version number and the word version is space delimited or not
if NOT delimited use this code, save it to a file... use file name as arguments
example:
script.sh filename
echo "file ${1} contains `grep -c fail ${1}` fails"
for x in `grep fail ${1} | sort -u | cut -f1 -d" "`
do
echo "version ${x} contains `grep -c fail ${1} | grep -c ${x}` count"
done
if delimited just change cut -f1 -d" " to cut -f2 -d" "
thanks
getdpg
January 17, 2006, 9:04am
7
Sorry it is not working . i am writing my question again in details .
Example
The logs conatins 1000 records row by row . if test cases are failed then it prints Fail(s) at end of row .
I want to grep number of fails .
Please help me to grep this ...
waiting for reply thanks in advance
can you post the first 20 lines from the log file with few failure messages in it... then i can give you exact script
getdpg
January 17, 2006, 12:55pm
9
2006-01-17 09:32:39 #### Testsuite started (plugin: sicat)
2006-01-17 09:34:47 (devel: 11/526) Running daily/DB/SFM/SFMDoublePointHole2.exp ...
2006-01-17 09:34:48 (devel: 12/526) Running daily/DB/SFM/SFMDoublePointHull.exp ...
getdpg
January 17, 2006, 1:01pm
10
i posted the samle log file . i have to count number of test modules failing for devel version . ( count as 1 record as 1 fail ).
The log contains data for differnt version .
I need output like this
Version : Devel
Version : 9
Please help me
getdpg
January 17, 2006, 1:02pm
11
mahendraji pls reply me waiting for ur reply
kduffin
January 17, 2006, 1:08pm
12
Please remember the rules when posting to forums. For instance:
(4) Do not 'bump up' questions if they are not answered promptly. No duplicate or cross-posting and do not report a post where your goal is to get an answer more quickly.
Cheers,
Keith
getdpg
January 17, 2006, 1:21pm
13
sorry keith i wont repeat this mistake
getdpg
January 18, 2006, 8:12am
15
thanks a lot for ur reply and help ..
the fails records are filterd but not sum ..
one more thing i dont want to sum number of fails ...
i want to add number of failuers one record is one fail doesnt matter how many fails ..
pls do needful
$ more logfile
2006-01-17 09:34:47 (devel: 11/526) Running daily/DB/SFM/SFMDoublePointHole2.exp ...
2006-01-17 09:34:48 (devel: 12/526) Running daily/DB/SFM/SFMDoublePointHull.exp ...
$ grep fails logfile | cut -d":" -f3 | sed 's/.*(\(.*\)/\1/g' | uniq -c
or this,
awk -F":" ' /fails/ {print $3}' logfile | sed -e 's/^.*(//' | uniq -c
getdpg
January 18, 2006, 2:01pm
18
hello
sorry i am getting errors ,, Pls mahendraji reply me .. i need ur help
regards
please post the error when you are getting error, also post me the output what you are getting, i could not guess what is going on at your end..
i guess the file format is different from what you have posted above..
i have provided the command based on the file format you have given, if there is any change to that, you need to modify the command accordingly...
initially you gaved one example, i have provided the command based on that..
please note that this command would not work for any format, we need to make changes according to the format chat.
the command i have provided above works perfectly for the file format you have provided.
i would suggest you to take out 100 lines and excute the command i have provided above.
if it is not giving the output you expected, post me the 100 lines here and also the output from my command above and also your expected output...
replace urfile by the logfile name u want
Add the following lines in a script, give it execute permissions and execute it.
## grep the lines with word fails, take the last field delimited by :, replace leading
## incr a counter till the first field on each line is unchanged, once changed print out
awk 'BEGIN {
sirs,