Search Results

Hi, you kept in && NR > 1, that shouldn't be there..

--
So, records that are missing have a value of 0? Try:
awk -F, 'function pr(){printf "%s;%.2f\n",p,100*f/s} p!=$2{if(p)pr(); p=$2;...

This assumes that the value in the first column is always greater than zero:


awk -F , '
$2 != l && NR > 1 {
printf( "%s; %.3f\n", l, (f/sum) * 100 );
f = sum = $1;
...

I took a different approach that assumed the config file couldn't be changed.


awk -F "," '
NR != FNR {
gsub( "\"", "", $0 );
x = $3 " " $2;
if( x in tab1 && $13...

Is that the way your conf file has to be, or can you reorganize it as you please? That's not how I'd have organized it, it takes a bit more processing that way... Just simple files like
name1...

Here is something probably much faster than your previous attempts:

startDate="2012/01/01 00:00:00"
endDate="2012/04/15 00:00:00"
gawk -F'","' \
-v start=${startDate//[\/ :]/} \
-v...

I get the same error using mawk. Try using gawk instead of mawk