Hi Experts,

please see below are the dynamic text files.

abc,445,hhh,data,10,country,data,88,city
abc,445,hhh,data,10,country,data,88,city
abc,445,hhh,data,10,country,data,88,city
abc,445,hhh,data,10,country,data,200,city
abc,445,hhh,data,10,country,data,88,city,games,100 ,data,20,basket
abc,445,hhh,data,10,country,data,88,city,games,100 ,data,20,basket
abc,445,hhh,data,10,country,data,88,city,games,100 ,data,220,basket

I need a shell script which can show me those lines which is having data greater than 200.
for example in the below line
abc,445,hhh,data,10,country,data,88,city
script should add the data value like 10+88=98 and if the value is greater than 200 it should print the whole line like
abc,445,hhh,data,10,country,data,88,city,games,100 ,data,220,basket
data =10+88+220 is greater than 200 so it should print the whole line.

Note the data value is dynamic it can appera many times in the file.

Thanks

Shary

Please post what you've tried so far.
If this is a course work then please post full question.

Mike

Dears,

The problem is the text which i have mentioned is dynamic and so far i can not understand how to deal with dynamic fields like data string can appear many times in the file and i want to calculate the next filed after the data string and then sum up all the numbers coming just after the data and compare with 200 and if it is greater than 200 then the script should display me those lines

• Set up a for loop to read each line.
• Remove all characters from the line that are not numbers but remember to separate the numbers from each other (use sed command).
• Loop through each number adding them up (look up expr command ie COUNT=`expr $COUNT + 1`).
• If greater than 200 then print out original line.