Hi Frnds,

I have a text file confdate.txt with the following format.

From_Date 12-02-2007
To_Date 12-03-2007

Now i have two variables say new_todate,new_fromdate in my shell script which contains two new dates,and i want to update the dates in the flat file corresponding to the column using awk.

Can you please give me some inputs on this?

Thanks in Advance.
- Raja.

You can try like this:

Using awk: $x and $y are the new values to be set

Could you please explain me both when you find time?

hey its not working ya.

$ dt=`date -u +%d-%m-%y`
$
$ echo $dt
29-01-08
$
$ cat tst.txt
Date 12-01-08
$
$ awk -v dat=$dt -v '{if( $1 ~ /Date/) print $1" "dat;}' tst.txt
Usage: awk [-F fs][-v Assignment][-f Progfile|Program][Assignment|File] ...
$
$ sed -e 's/Date\(.*\)/Date '$dt'/' tst.txt
Date 29-01-08
$ cat tst.txt
Date 12-01-08
$

what is wrong with my command?

Why you have used -v there? Also, if you want these changes to written on to a file, you have to use "> new_filename" at the end...

ie, sed -e 's/Date\(.*\)/Date '$dt'/' tst.txt > temp_new_file

still it did not updated frnd,

$ dt=`date -u +%d-%m-%y`
$
$ echo $dt
29-01-08
$
$ cat tst.txt
Date 12-01-08
$
$ awk -v dat=$dt '{if( $1 ~ /Date/) print $1" "dat;}' tst.txt
Date 29-01-08
$
$
$ cat tst.txt
Date 12-01-08
$

Please read carefully my friend...