#!/bin/awk -f BEGIN { FS = ","; LASTNAME = 1; FIRSTNAME = 2; PARTY = 3; STATE = 4; DISTRICT = 5; CHAMBER = 6; ROOM = 7; BLDING = 8; ZIP = 9; VOICEPHONE = 10; FAX = 11; EMAIL = 12; NUM_STD_FIELDS = 12; COMMITTEE_START = 13; ENTIRE_RECORD = 0; EMPTYSTR = ""; CHAMBER_HOUSE = "H"; CHAMBER_SENATE = "S"; } # # for committee searches # !/^#/ && NF > NUM_STD_FIELDS { for (i = COMMITTEE_START ; i <= NF ; i++) { if ($i == COMMITTEE_NAME_HERE) { print $ENTIRE_RECORD; } } } # # for other searches # !/^#/ && NF >= NUM_STD_FIELDS { print $ENTIRE_RECORD; } # # for house searches # !/^#/ && NF >= NUM_STD_FIELDS && $CHAMBER == CHAMBER_HOUSE { print $ENTIRE_RECORD; } # # for senate searches # !/^#/ && NF >= NUM_STD_FIELDS && $CHAMBER == CHAMBER_SENATE { print $ENTIRE_RECORD; }