: !/bin/sh insightcdr="/u/catcom/wb/ex2_tst/indata/Oct_2009/OPTUSINSIGHTCDR/mobile_phones/10004_Oct09.csv" datafeed="/u/catcom/wb/ex2_tst/indata/Oct_2009/OPTUS/mobile_phones/10004_20091027.bil" rm -f onmob*.out ( runisql 2>/dev/null < 0 ) print $0 >>"onmob_insight.out" } ' sed -e 's/"//g;s/,/|/g;s/ $//;s/"$//' "$datafeed" | \ awk -F'|' -v "onmobile=$onmobile" ' function trim(s) { sub(/^[ \t]*/,"",s) sub(/[ \t]*$/,"",s) return s } { DialledNumber = trim($9) # datafeed #print "onmobile=[" onmobile "]" " DialleNumber=[" DialledNumber "]" if ( index(DialledNumber,substr(onmobile,2,9)) > 0 ) print $0 >>"onmob_datafeed.out" } ' done