[nSLUG] gawk... @#^&##&^!!- ;-)

David Potter dlpotter at eastlink.ca
Thu Mar 11 16:11:27 AST 2010


My poor, old, head is fried so I'll not suggest the logic is correct.
I'm trying to find records that have $1 identical , save  $3 from the
first (as new record number) and sent the new record# and the old
record# to output.

I'm getting an odd, recurring error that has me wondering if there is a
bug in this version of gawk - I know, I know... poor workman to blame
the tools... ;-)

Data in:

0005b186aaaf0114b60685e2ea5a1a41  -:new:33619
0008d656ad44e3167a673d5859c23aa8  -:new:20788
0008d656ad44e3167a673d5859c23aa8  -:old:01123
000e63eefbd422fb00c73cd3fcd034d8  -:new:13135
00106f312cdfa88965c2d9d6d933a144  -:new:05629
0012c059f0b1a4ae7ca31f09d643d0db  -:new:12496
00161f484478012ee57f309ae79f4111  -:new:32212
0018f8aba382f6b4a04e7f29031e0e58  -:new:10048
0018f8aba382f6b4a04e7f29031e0e58  -:old:05921
0019cd240cd81f41607f7b60eaf86ec2  -:new:36133
0019cd240cd81f41607f7b60eaf86ec2  -:old:04200
001dd3feb1716aadc0ac50f8f3371feb  -:new:39733
001fa91f4dcbae90e6a33c51aea620c9  -:new:24385
002c181d94759cada0b629bf91e51015  -:new:41545
002ded4193a37217568d0e93ba776498  -:new:35305
002e3cd58b2efe701dc6517d5998a7cf  -:new:07687
002e3cd58b2efe701dc6517d5998a7cf  -:old:03802
002e959175c5e73273752e743c2536bf  -:new:17593
002e959175c5e73273752e743c2536bf  -:old:03161
002ff56b75a72bdcca401ff9bba14907  -:new:35167

Ubuntu - gawk

#!/bin/bash

cat /tmp/hash_combined | sed -e 's/[ \t\-]*//g' | gawk -F: ' 
{

# testing...
print $0
# end testing...

if ($hash == $1) { printf("new:%s:old:%s\n", $new_id, $3);
hash=$1; new_id=$3; next; }

else { hash=$1; new_id=$3; next; }

}'

Output

0005b186aaaf0114b60685e2ea5a1a41:new:33619
0008d656ad44e3167a673d5859c23aa8:new:20788
0008d656ad44e3167a673d5859c23aa8:old:01123
000e63eefbd422fb00c73cd3fcd034d8:new:13135
00106f312cdfa88965c2d9d6d933a144:new:05629
0012c059f0b1a4ae7ca31f09d643d0db:new:12496
00161f484478012ee57f309ae79f4111:new:32212
0018f8aba382f6b4a04e7f29031e0e58:new:10048
0018f8aba382f6b4a04e7f29031e0e58:old:05921
0019cd240cd81f41607f7b60eaf86ec2:new:36133
0019cd240cd81f41607f7b60eaf86ec2:old:04200
001dd3feb1716aadc0ac50f8f3371feb:new:39733
001fa91f4dcbae90e6a33c51aea620c9:new:24385
new::old:24385
002c181d94759cada0b629bf91e51015:new:41545
new::old:41545
002ded4193a37217568d0e93ba776498:new:35305
002e3cd58b2efe701dc6517d5998a7cf:new:07687
002e3cd58b2efe701dc6517d5998a7cf:old:03802
002e959175c5e73273752e743c2536bf:new:17593
002e959175c5e73273752e743c2536bf:old:03161
gawk: cmd. line:11: (FILENAME=- FNR=19) fatal: attempt to access field
-2147483648

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nslug.ns.ca/mailman/private/nslug/attachments/20100311/e416aaf4/attachment-0002.html>


More information about the nSLUG mailing list