I have a file with a format of
A,2
B,2
G,3
A,2
A,3
A,2
D,7
A,2
E,2
A,2
I need to create a sum of each alphabet with the numbers assigned to it using awk.
I have a file with a format of
A,2
B,2
G,3
A,2
A,3
A,2
D,7
A,2
E,2
A,2
I need to create a sum of each alphabet with the numbers assigned to it using awk.
# awk -F"," '{cnt[$1]+=$2}END{for (x in cnt){print x,cnt[x]}}' infile
A 13
B 2
D 7
E 2
G 3
Did you want a pseudo hash algorithm and checksum based on line content or a simple
occurrence sum (already provided above)?
Here's the former.
function makesimplehash(data,seedval, n,x,hashval,store,p) {
for (n = 1 ; data[n] != 0 ; n++) {
x = sprintf("%d",data[n])
if (x == 0) {
gencharsarr(store)
for (p=0 ; p < 10 ; p++) {
if (store[p] == data[n]) {x = p + 1; break;}
}
}
#printf "Derived value %d from %d\n",x,data[n]
hashval += int(x + seedval % (n + 1))
}
return hashval
}
function zeroarr(data,nv, x) {
while (x < nv) {data[x] = 0; x++}
}
function gencharsarr(data, n) {
str="abcdefghijk"
for (n=0 ; n < 10 ; n++) {data[n]=substr(str,n,1)}
}
function createhashable(szl, store,str,vn) {
store[0]=""
gencharsarr(store)
for (vn=0 ; vn < szl + 1; vn++) {
if (vn == 0) {str = store[int(1 + rand() * 9)]; continue}
str = str "," int(1 + rand() * 10)
}
return str
}
BEGIN {
arra[0]=""
cnt=0;sz=0
if (ARGC == 2 && ARGV[1] == "-generate") {
srand()
while (cnt < 20) {
sz = int(1 + rand() * 7)
print createhashable(sz)
cnt++
}
exit
}
}
{
FS=","
if ( (num = split($0,arra)) == 0) {printf "At record number %d, malformed field content.\n",NR ; next}
arra[num + 1] = 0;
#for (a = 1 ; a <= num ; a++) {print a,arra[a]}
printf "Hash value for %s = %d.\n",$0,makesimplehash(arra,15003)
zeroarr(arra,num)
}