Question: Linux So I have the following data in a file called animal.txt: There once was a Bear he ate carrots he ate chicken There once

Linux

So I have the following data in a file called animal.txt:

There once was a Bear

he ate carrots

he ate chicken

There once was a Dog

he ate carrots

he ate Apples

And I need an output like the following:

Food: Apples Count: 1

=======

Dog

Food: Carrots Count: 2

========

Bear

Dog

Food: Chicken Count: 1

========

Bear

So far I have the following:

awk '$2=="ate"{print $3;}' animal.txt | sort | uniq -c | awk '{printf "Food: "} { print $2 " Count: "$1} {print"==============================="}{print""}'

And it gets me the Food line and the count, but I can't figure out how to get the animals below each line for the food that they eat.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!