#!/usr/bin/gawk -We

function get_content(line){
	gsub(/<\/gnm:Cell>/, "", line)
	gsub(/[^>]*>/, "", line)
	return line
}

BEGIN {
	}
/Col="0"/{
	fname=""
	lname=""
	addr1=""
	addr2=""
	city=""
	state=""
	zip=""
	print "STARTT"
}

/Col="1"/ {fname = get_content($0)}
/Col="2"/ {lname =  get_content($0)}
/Col="3"/ {addr1 =  get_content($0)}
/Col="4"/ {addr2 =  get_content($0)}
/Col="5"/ {city =  get_content($0)}
/Col="6"/ {state =  get_content($0)}
/Col="7"/ {zip =  get_content($0)}
/Col="19"/ {
	print fname " " lname
	print addr1
	if(addr2 != ""){print addr2}
	print city ", " state ", " zip
}
/Col="24"/ {print "ENDD"}