Search Results

this awk command did the trick:
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|"...

Thanks a lot Don, this is definitely a good start. I am doing some reading in order to get a better understanding of UNIX scripting.

No Don, this is not homework assignment. This is actual job/work that I was asked to amend as the developer is off on vacation.

I need to amend the code blow such that it reads a "black list" before the "print" statement; if "substr($1,1,6)" is found in the "blacklist" it will ignore that record and continue. the code is from...