[FIXED] combining numbers from multiple text files using bash

Issue

I'm strugling to combine some data from my txt files generated in my jenkins job.

on each of the files there is 1 line, this is how each file look:

testsuite name="mytest" cars="201" users="0" bus="0" bike="0" time="116.103016"

What I manage to do for now is to extract the numbers for each txt file:

awk '/<testsuite name=/{print $3, $4, $5, $6}' my-output*.txt 

Result are :

cars="193" users="2" bus="0" bike="0"
cars="23" users="2" bus="10" bike="7"
cars="124" users="2" bus="5" bike="0"
cars="124" users="2" bus="0" bike="123"

now I have a random number of files like this:

my-output1.txt
my-output2.txt
my-output7.txt
my-output*.txt

I would like to create single command just like the one I did above and to sum all of the files to have the following echo result:

cars=544 users=32 bus=12 bike=44

is there a way to do that? with a single line of command?

Solution

found a way to do so a bit long:

awk '/<testsuite name=/{print $3, $4, $5, $6}' my-output*.xml | sed -e 's/[^0-9]/ /g' -e 's/^ *//g' -e 's/ *$//g' | tr -s ' ' | awk '{bus+=$1;users+=$2;cars+=$3;bike+=$4 }END{print "bus=" bus " users="users " cars=" cars " bike=" bike}'

M. Nejat Aydin answer was good fit:

awk -F '[ "=]+' '/testsuite name=/{ cars+=$5; users+=$7; buses+=$9; bikes+=$11 } END{ print "cars="cars, "users="users, "buses="buses, "bikes="bikes }' my-output*.xml

Answered By - DevFromI
Answer Checked By - David Marino (JavaFixing Volunteer)