UNIX for Dummies Questions & Answers

BEGIN { "date +%d/%m/%Y" | getline dateVal; FS = "|" }

{ print "CCA|" $1 "||" substr($1,1,6) "|" substr($1,7,10) "||A|" dateVal "|" dateVal "|Y|N|31"; }

BEGIN { "date +%d/%m/%Y" | getline dateVal; FS = "|" }
   blist='cat /tmp/bad_values.txt'
    if !substr($1,1,6) in blist then ##here the code will read the entire blist
{ print "CCA|" $1 "||" substr($1,1,6) "|" substr($1,7,10) "||A|" dateVal "|" dateVal "|Y|N|31"; }

123456
678901
456789

BEGIN {	FS = "|" 
	"date +%d/%m/%Y" | getline dateVal
	close("date +%d/%m/%Y")
	while((getline item < "blacklist") == 1) bl[item]
	close("blacklist")
}
!(substr($1,1,6) in bl) {
	printf("CCA|%s||%s|%s||A|%s|%s|Y|N|31\n", $1, substr($1,1,6),
		substr($1,7,10), dateVal, dateVal)
}

BEGIN { "date +%d/%m/%Y" | getline dateVal; FS = "|" }  

NR==FNR{a[$1];next} !(substr($1,1,6) in a) {print "CCA|" $1 "||" substr($1,1,6) "|" substr($1,7,10) "||A|" dateVal "|" dateVal "|Y|N|31"; }