Compare rows using awk

Shell Programming and Scripting
1

Hi,

i want to compare all the rows of columns A and if it same then need to add its corresponding value column B and print it as a new column.

eg.
/vol/_1ACIFS02,482259,
/vol/_1BCIFS01,122451,
/vol/_2CCIFS02,2310,
/vol/_2CCIFS04,11508,
/vol/_2CCIFS04,8461,
/vol/_525e0e05_56e6_4acb_b655_eb9b2324d839_t1000_snap_1,20529,
/vol/_7201_SPBSVM1_A1_SSD_15_HI,425,
/vol/_7201_SPBSVM1_A1_SSD_15_HI,89265,
/vol/_7201_SPBSVM1_A1_SSD_15_HI,50770,
/vol/_7201_SPBSVM1_A1_SSD_21,0,
/vol/_7201_SPBSVM1_A1_SSD_22,0,
/vol/_7201_SPBSVM1_A2_SSD_16_HI,44061,
/vol/_7201_SPBSVM1_A2_SSD_16_HI,75787,
/vol/_7201_SPBSVM1_A2_SSD_17_V,1013,
/vol/_7201_SPBSVM1_A2_SSD_19_CDEFP,145740,
/vol/_7201_SPBSVM1_A2_SSD_19_CDEFP,773594,

output:
/vol/_1ACIFS02,482259,482259
/vol/_1BCIFS01,122451,122451
/vol/_2CCIFS02,2310,2310
/vol/_2CCIFS04,11508,19969
/vol/_2CCIFS04,8461,19969
/vol/_525e0e05_56e6_4acb_b655_eb9b2324d839_t1000_snap_1,20529,20529
/vol/_7201_SPBSVM1_A1_SSD_15_HI,425,140460
/vol/_7201_SPBSVM1_A1_SSD_15_HI,89265,140460
/vol/_7201_SPBSVM1_A1_SSD_15_HI,50770,140460
/vol/_7201_SPBSVM1_A1_SSD_21,0,0
/vol/_7201_SPBSVM1_A1_SSD_22,0,0
/vol/_7201_SPBSVM1_A2_SSD_16_HI,44061,119848
/vol/_7201_SPBSVM1_A2_SSD_16_HI,75787,119848
/vol/_7201_SPBSVM1_A2_SSD_17_V,1013,1013
/vol/_7201_SPBSVM1_A2_SSD_19_CDEFP,145740,919334
 /vol/_7201_SPBSVM1_A2_SSD_19_CDEFP,773594,919334
2

Your logical description does not seem to fit. For example:

/vol/_7201_SPBSVM1_A1_SSD_15_HI,425,140460
/vol/_7201_SPBSVM1_A1_SSD_15_HI,89265,140460
/vol/_7201_SPBSVM1_A1_SSD_15_HI,50770,140460

140460 does not appear in the input. But per your logic those rows should have 425, 89265, and 50770 at the end.

3

Basically it is a summation of all the values if column A is same.

eg.)

/vol/_7201_SPBSVM1_A1_SSD_15_HI,425,
/vol/_7201_SPBSVM1_A1_SSD_15_HI,89265,
/vol/_7201_SPBSVM1_A1_SSD_15_HI,50770,

425+89265+50770 = 140460 which needs to be printed in all the rows which are considered.

4

Users from Bangalore need to use code tags and follow forum rules:

route:          202.3.121.0/24
descr:          NETAPP BANGALORE IN
origin:         AS24477
mnt-by:         MAINT-IN-NETAPP
last-modified:  2016-09-15T08:15:56Z
source:         APNIC
5

Is the input file sorted? Does output order matter? Any attempts / ideas / thoughts from your side?

And - did you consider searching these forums as this problem has been solved umpteen times in here.