Search Results

Using shell builtins (sh, bash and probably others too)
#!/bin/sh

a='testfile.test.txt'

echo "Filename: ${a%.*}"
echo "Extension: ${a##*.}"

exit 0

f=testfile.txt ; a=`basename $f ".txt"` ;echo $a

Great :D

But I imagine it's CalDayRunDt that you explicitly wanted to change.


$ sed "/CalDayRunDt/ s/'.*/'$curdate'/" file1
,TotUnasgndNetAmt
FROM DEV_EIS_T.Wkly_SO_CCD_MOSumSnpsht
WHERE...

$ 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