Search Results

$ cat file1
,TotUnasgndNetAmt
FROM DEV_EIS_T.Wkly_SO_CCD_MOSumSnpsht
WHERE
CalDayRunDt = '2010-07-21'
UNION ALL
SELECT
CalDayRunDt
,BusWkCd
,'N'


$ curdate=something
$ sed...

Try: awk -vx=$curr_date '{sub("....-..-..",x,$0)}1' file

Sorry, there were some unneeded characters in the last command. Try now: awk '/DEV_EIS_T/{printf "\n"$0;next}{printf $0}' file