Ideone.com

fork download

copy

#!/bin/bash
 
awk '/X/ {
    k = substr($0, length($1)+2)
    sub(/X.*/, "", k)
    a[k] += $1
}
END {
    for(k in a)
        print(a[k], k)
}'

Success #stdin #stdout 0.01s 5272KB

stdin

copy

2 mumbaiXa
3 mumbaiXb
1 mumbaiXp
5 delhiXn
4 delhiXz
1 parisXs
7 parisXt
1 parisXa
9 parisXe
42 new yorkXzz

stdout

copy

9 delhi
42 new york
6 mumbai
18 paris

https://ideone.com/G4ZwJR

https://stackoverflow.com/questions/78931497/calculate-subtotals-of-the-output-of-sort-unique-command

language:

Bash (bash 5.0.3)

created:

visibility:

secret

Share or Embed source code

The brand new service which powers Ideone!

Widget for compiling and running the source code in a web browser!