Shell Programming and Scripting

Hi Anbu,

Your script is working perfectly fine.But i have got into a new problem...
Please look at these file names

BP_aaa_bbb_20070323050007.dat
BP_ccc_ddd_032307.dat
BP_aa_bb_032307.dat
BP_dd_ee_032307.dat
BP_ff_gg_032307.xls
BP_xx.yy_20070323134501.dat (apart from date,the other digits vary from day to day )
BP_ss_pp_20070323030002.dat

Now i dont know how to dynamically update the date portion of these files

Please help me in this regard.

Thanks a ton,
Kumar

Do not use tcsh for scripting.

You are probably using a Bourne shell. You should use a POSIX shell for scripting; there is probably one installed on your system. Check your documentation for the location.

In the unlikely event that there isn't one (it could be bash or ksh or ash), change $( ... ) to ` ... `:

Code:

dt=`date"+%b-%d-%y"`

I got this script from Anbu which when run would append the date portion to the end of my files.

*********************************
dt=$( date "+%b-%d-%Y" )
for i in *
do
mv $i ${i}".${dt}"
done
***************************************

Can you please tell me how to append date of this format 032307 and 20070323 in the middle of the file name as show below and dynamically update it everyday.

TP_ccc_ddd_032307.txt
aa_bb_032307.dat
BP_dd_ee_032307.dat
BP_ff_gg_032307.xls
BP_xx_yy_20070323134501.dat

Can you please also help me with a comparison command.I mean i want to
extract only BP_xx_yy20070323.dat from the below file and compare it with a file list i have manually created.

BP_xx_yy_20070323134501.dat

Please help me in this regard.

Thanks a ton,
Kumar

You mean insert the date into the filename (append means to place at the end).

First you need to break the file name into its various parts: name, date and suffix:

Code:

file=TP_ccc_ddd_032307.txt
suffix=${file##*.}
name=${file%_*}
temp=${file%."$suffix"}
date=${temp#"$name"_}

Then you need to convert the date. You show two different formats, so two different conversion functions must be used. The first format is the ridiculous MMDDYY; the second, I assume, is YYYYMMDDHHMMSS.

To determine which format the date is in, check the length:

Code:

case ${#date} in
  6) six2date ;;
  14) fourteen2date ;;
esac

Then reassemble the filename and do the move:

Code:

newfile=${name}_$_DATE.$suffix
mv "$file" "$newfile"

Here are the other functions you will need:

Code:

monthname()
{
  case $1 in
    01) _MONTH=Jan ;;   02) _MONTH=Feb ;;
    03) _MONTH=Mar ;;   04) _MONTH=Apr ;;
    05) _MONTH=May ;;   06) _MONTH=Jun ;;
    07) _MONTH=Jul ;;   08) _MONTH=Aug ;;
    09) _MONTH=Sep ;;   10) _MONTH=Oct ;;
    11) _MONTH=Nov ;;   12) _MONTH=Dec ;;
  esac
}

six2date()
{
   temp=${1#??}
   year=$(( ${1%"$temp"} + 2000 )) ## Fix if last century is possible
   monthname "${temp%??}"
   day=${temp#??}
   _DATE=$_MONTH-$day-$year
}

fourteen2date()
{
   temp1=${1#????}
   year=${1%"$temp1"}
   temp2=${temp1#??}
   monthname ${temp1%"$temp2"}
   temp3=${temp2#??}
   day=${temp2%"$temp3"}
   _DATE=$_MONTH-$day-$year
}

Hi,

When pass the file input to this script,it is stripping off all the numerals..i dont know if i'm doing something wrong here...

Input = BP_x_yy_20070323134501.dat
Ouput = BP_x_yy_.dat

Output i'm expecting is it should replace the date with todays date...something like this..

BP_x_yy_20070327134501.dat

#!/bin/ksh

cd /tmp/sa/script

file=BP_x_yy_20070323134501.dat
suffix=${file##*.}
name=${file%_*}
temp=${file%."$suffix"}
date=${temp#"$name"_}

case ${#date} in
6) six2date() ;;
14) fourteen2date() ;;
esac

newfile=${name}_$_DATE.$suffix
mv "$file" "$newfile"

monthname()
{
case $1 in
01) _MONTH=Jan ;; 02) _MONTH=Feb ;;
03) _MONTH=Mar ;; 04) _MONTH=Apr ;;
05) _MONTH=May ;; 06) _MONTH=Jun ;;
07) _MONTH=Jul ;; 08) _MONTH=Aug ;;
09) _MONTH=Sep ;; 10) _MONTH=Oct ;;
11) _MONTH=Nov ;; 12) _MONTH=Dec ;;
esac
}

six2date()
{
temp=${1#??}
year=$(( ${1%"$temp"} + 2000 ))
monthname "${temp%??}"
day=${temp#??}
_DATE=$_MONTH-$day-$year
}

fourteen2date()
{
temp1=${1#????}
year=${1%"$temp1"}
temp2=${temp#??}
monthname ${temp1%"$temp2"}
temp3=${temp2##??}
day=${temp2%"$temp3"}
_DATE=$_MONTH-$day-$year
}

Call functions with arguments

Code:

case ${#date} in
6) six2date ${date} ;;
14) fourteen2date ${date} ;;
esac

Add 1

Code:

fourteen2date()
{
temp1=${1#????}
year=${1%"$temp1"}
temp2=${temp1#??}
monthname ${temp1%"$temp2"}
temp3=${temp2##??}
day=${temp2%"$temp3"}
_DATE=$_MONTH-$day-$year
}

Hi,

I did make the changes you mentioned above and when i execute it gives me an error.But the script is able to make up whether the file is six2date or fourteen2date function.

> ./test.sh
./test.sh[12]: six2date: not found
>

If i do not pass any arguments to the function,it executes without any error but the date doesnt get replaced..it is completely stripped off from the file name...

#!/bin/ksh

cd /tmp/sa/script

file=TP_xx_yy_032307.txt
suffix=${file##*.}
name=${file%_*}
temp=${file%."$suffix"}
date=${temp#"$name"_}

case ${#date} in
6) six2date ${date} ;;
14) fourteen2date ${date};;
esac

newfile=${name}_$_DATE.$suffix
mv "$file" "$newfile"

monthname()
{
case $1 in
01) _MONTH=Jan ;; 02) _MONTH=Feb ;;
03) _MONTH=Mar ;; 04) _MONTH=Apr ;;
05) _MONTH=May ;; 06) _MONTH=Jun ;;
07) _MONTH=Jul ;; 08) _MONTH=Aug ;;
09) _MONTH=Sep ;; 10) _MONTH=Oct ;;
11) _MONTH=Nov ;; 12) _MONTH=Dec ;;
esac
}

six2date()
{
temp=${1#??}
year=$(( ${1%"$temp"} + 2000 ))
monthname "${temp%??}"
day=${temp#??}
_DATE=$_MONTH-$day-$year
}

fourteen2date()
{
temp1=${1#????}
year=${1%"$temp1"}
temp2=${temp1#??}
monthname ${temp1%"$temp2"}
temp3=${temp2##??}
day=${temp2%"$temp3"}
_DATE=$_MONTH-$day-$year
}