Hi,

I need a script that moves files based on date to a folder. The folder should be created based on file date. Example is :

Date file name
----- --------
Oct 08 07:39 10112012_073952.xls
Oct 09 07:39 10112012_073952.xls
Oct 10 07:39 10112012_073952.xls
Oct 11 07:39 10112012_073952.xls

and it should create like below :

Folder names should be like:

08Oct2012
09Oct2012
10Oct2012
11Oct2012

Files should be moved to respective folders based on date like :

08Oct2012 -->Oct 08 07:39 10112012_073952.xls
09Oct2012 -->Oct 09 07:39 10112012_073952.xls
10Oct2012 -->Oct 10 07:39 10112012_073952.xls
11Oct2012 -->Oct 11 07:39 10112012_073952.xls

Let me know the script how to achieve this.

#!/bin/ksh
typeset -R4 yy
for i in *.xls
do
  a=($(echo $i))
  y=${a[3]}
  y=${y##* }
  y=${y%%_*}
  yy=$y
  [[ -d ${a[1]}${a[0]}$yy ]] || mkdir ${a[1]}${a[0]}$yy
  mv -f "$i" ${a[1]}${a[0]}$yy
done

Hi rdrtx1,

I'm getting error at line number 5 as :

./movefiles.sh[3]: syntax error at line 5 : `(' unexpected

I figured it out that
a=($(echo $i))

it should be like :

a=$(echo $i)
But I'm not getting desired output, Please check and tell me.

#!/bin/ksh
typeset -R4 yy
for i in *.xls
do
  echo $i | read m d y
  y=${y##* }
  y=${y%%_*}
  yy=$y
  dir=$d$m$yy
  [[ -d $dir ]] || mkdir $dir
  mv -f "$i" $dir
done

Its still not working :

$ ./movefiles.sh
mkdir: cannot create 10112012_073952.xls
10112012_073952.xls: File exists
mv: 10112012_073952.xls.xls and 10112012_073952.xls are identical.

Just small question , the code given by you has :

#!/bin/ksh typeset -R4 yy for i in *.xls do echo $i | read m d y y=${y##* } y=${y%%_*} yy=$y dir=$d$m$yy [[ -d $dir ]] || mkdir $dir mv -f "$i" $dir done
echo $i | read m d y y=${y##* } ----------------> I think it should be m y=${y%%_*} ----------------> it should be d yy=$y
Let me know your comments.

Moderator's Comments:

Please use code tags next time for your code and data.

Here's something else:

#!/bin/bash

MONTH="$(date +'%d''%b''%Y')"

FILES="$(date +'%d''%m''%Y')"

mkdir "${MONTH}"

mv ${FILES}_*.xls ${MONTH}

Hi hedkandi,

According to you it will create the folder with current date. I want folder to be created based on file date and then file should move to the folder for which date it belongs.

Any help much appreciated.