Grep Multiple Lines with Unique Count and String

A simple solution is to use the following pipe:

<Sample.csv grep '^[^,]*,[^,]*,FAILURE' | cut -d, -f2 | sort | uniq -c

• grep will extract lines with FAILURE in the third column
• cut will extract the column (separator , column number 2)
• sort will sort the extracted column (The same values will be next to each other.)
• uniq will remove repeated values, the -c option will show counts of every unique value

You can also insert other filters into the pipe as needed. (for example grep at the beginning).

Ricky's comment is how I would do it, but if you want a solution specific to grep you could do the following:

$ for i in {abc,def}; do echo -n "$i: "; grep -c $i input.txt; done;

this will output the expected:

abc:5
def:2

Update

If you do not want to include the search keys in the for loop I don't see how to do it simply with just grep.

You could do it with awk though.

awk 'BEGIN{FS=","}//{a[$2]++}END{for(x in a) print x,a[x]}' test.txt

Explanation:

FS="," -- set record seperator to comma

// -- match all lines

We create an associate array called 'a'

a[$2]++ -- each pattern matched we take 2nd column and increment count

END { .. } -- this block is run when done with all matching. we iterate over all elements printing key and count.

please find the same:

awk < Sample.txt -F',' '{print $2}' | sort |uniq -c| grep "FAILURE"

Thanks for your answers :)