Shell Programming and Scripting

hi

i am trying to match filenames and modify the files internally depending on the match
the filenames are something like this
cm01FEB2012bhav
cm01AUG2012bhav
...

Internally the file(cm01FEB2012bhav) looks like this

20MICRONS,EQ,64.1,65.7,62.45,63.7,64.5,64.1,113043,01-FEB-2012
3IINFOTECH,EQ,16,16.3,15.5,16.1,16.1,15.8,2797315,01-FEB-2012
3MINDIA,EQ,3560,3599,3420,3451.8,3450,3597.75,1615,01-FEB-2012
.......

Here i am trying to replace 01-FEB-2012 with 01/02/2012(the filename is cm01FEB2012bhav).As you can see the filename and this field are almost the same.

I have written the code for matching the file cm01FEB2012bhav. I intend to write such if statements for all 12 possibilities(JAN,FEB,MAR...).However the first if statement is only not working .
Any help in solving this problem is appreciated

Code:

#!bin/bash
for file in *.csv;do
if [ "$file" = "cm[0-9][0-9]FEB[0-9][0-9][0-9][0-9]bhav\.csv" ]
then
sed 's^\(..\)\-\(...\)\-\(....\)^\1\/02\/\3^' $file
fi
done

Code:

#!/bin/bash

for file in *.csv
do
        DD=`echo ${file} | cut -c 3-4`
        MM=`echo ${file} | cut -c 5-7`
        YY=`echo ${file} | cut -c 8-11`
        SR_STR=`echo $DD-$MM-$YY`
        RP_STR=`date --date="$DD-$MM-$YY" +"%d/%m/%Y"`
        sed 's:'$SR_STR':'$RP_STR':g' ${file}
done

The code is working fine. I want to redirect the output to a file. how do I do that?

You can redirect the output by performing the following modification:-

Code:

sed 's:'$SR_STR':'$RP_STR':g' ${file} > output_file

But if you want to replace the content in the same file, then you can redirect the output to a tmp file and then rename it back to original file.

Code:

sed 's:'$SR_STR':'$RP_STR':g' ${file} > tmp; mv tmp ${file}

Thanks a lot!