|
|
How to put count for first element in a file at the end
07-29-2010
awk '
BEGIN { FS=OFS="|" }
NR==1 {
first=$1
}
{
count[$1]++;
last =$1;
key[NR] =$1;
rec[NR] =$0;
}
END {
count[first]--;
count[last]--;
print rec[1];
for (r=2; r<NR; r++) print rec[r],count[key[r]],"";
print rec[NR];
}
' donad.txtFHDR|ABC|20100607| |ABC|8453|CDE|E166|||| 123|ABC|8453|CDE|E166|||| 123|ABC|8453|CDE|E166|||| 111|ABC|8453|CDE|E166|||| 124|ABC|8453|CDE|E166|||| 124|ABC|8453|CDE|E166|||| TRLR|000000022|
FHDR|ABC|20100607| |ABC|8453|CDE|E166|||||1| 123|ABC|8453|CDE|E166|||||2| 123|ABC|8453|CDE|E166|||||2| 111|ABC|8453|CDE|E166|||||1| 124|ABC|8453|CDE|E166|||||2| 124|ABC|8453|CDE|E166|||||2| TRLR|000000022|
07-29-2010
# ./justdoit FHDR|ABC|20100607| |ABC|8453|CDE|E166||||0| 123|ABC|8453|CDE|E166||||2| 123|ABC|8453|CDE|E166||||2| 111|ABC|8453|CDE|E166||||1| 124|ABC|8453|CDE|E166||||2| 124|ABC|8453|CDE|E166||||2| TRLR|000000022|
#!/bin/bash
x=0
for i in `cat infile`
do
array[x]=`echo $i | sed 's/\([^|][A-Z0-9]*\)|.*/\1/'`
((x++))
done
#array[${#array[*]}-1]=""
x=1;c=-1
first=0
count=`echo ${#array[*]}`
sed -n '1p' infile
while [ $(( count -=1 )) -gt 1 ]
do
for i in ${array[@]}
do
my=${array[x]}
if [[ $my == $i ]]; then
((c++))
fi
done
((x++))
if [ $my != 111 ] && [ $my != 124 ] ; then
sed -n "/^$my/{s/$/$c|/;p;q}" infile
elif [ $my == 111 ] ; then
sed -n "/^$my/{s/^/ / ;s/$/$c|/;p;q}" infile
elif [ $my = 124 ] ; then
if [ $first -eq 0 ] ; then
sed -n "/^$my/{s/$/$c|/;p;q}" infile
(( first++ ))
else
sed -n "/^$my/{s/^/ / ;s/$/$c|/;p;q}" infile
fi
else
sed -n "/^$my/{s/$/$c|/;p;q}" infile
fi
c=0
done
sed -n '$p' infile|
|
|
|