UNIX for Advanced & Expert Users

Hi,

Im looking for a script which will calculate the unique strings column 2 & 3 values in a log as mentioned in example

eg:-
bag 12 12
bag 18 15
bags 15 13
bags 15 14
blazer 24 24
blazer 33 32
boots 19 15

Result should be:-
bag 30 27
bags 30 27
blazer 57 56
boots 19 15

Please help me on this!!!

Regards
wintech

Code:

awk '{a[$1]+=$2;b[$1]+=$3}END{for (i in a) print i,a[i],b[i]}' yourfile

Note that this code assume your file is already sorted on its first-column

If you want the output sorted :

Code:

awk '{a[$1]+=$2;b[$1]+=$3}END{for (i in a) print i,a[i],b[i]}' yourfile | sort

Thank You!!! Hurray it works perfect..... Thank you so much

---------- Post updated at 11:46 PM ---------- Previous update was at 11:34 PM ----------

Hi,

i have another small request, need to remove double/triple space in between a content to a single space in a file as below example.

File
bags 15 13
bags 15 14
blazer 24 24
blazer 33 32
boots 19 15

Result should be single space between the content
bags 15 13
bags 15 14
blazer 24 24
blazer 33 32
boots 19 15

Thanks
wintech

Code:

sed 's/  */ /g' filemanyspaced >filesinglespaced

or

Code:

tr -s ' ' <filemanyspaced >filesinglespaced

Hi,

Sorry!! double space is not removed to single space.

It should work
please not that there is a double space in the given sed rule :

s/ */ /g is s/<space><space>*/<space>/g

Please copy paste exactly what you have tried because for me it works fine :

Code:

$ echo ':       :'
:       :

Code:

$ echo ':       :' | sed 's/  */ /g'
: :

Code:

$ echo ':       :' | tr -s ' '
: :

Thank you!!! mistake is in my side sorry!!! command which you gave works fine..