[SOLVED] Move files into current dated folder

trickydba · 12-20-2016, 09:39 AM

I need to move all files with an extension of .xlsx into a folder that is named the current date. I have the dir automatically created daily:

mkdir $(date '+%Y%m%d')

and I have files in this format:

file_20161220.xlsx
file2_20161220.xlsx etc etc

and I need these files to be moved into the current dated folder daily. This is the format of the current dated folders:

12202016
12212016

Ratamahatta · 12-20-2016, 10:38 AM

Boils down to finding the name of the folder. You started this thread, so you already know the answer.

trickydba · 12-20-2016, 10:52 AM

@Ratamahatta...... I'm not quite sure I follow you. Yes I have the files with the current dates attached but I need these files moved to a folder that is named the current date as such:

12202016

I tried to create a variable: current_folder=mkdir $(date "+%Y%m%d")

Then change the permissions of that folder: chmod 777 /export/home/exg85/$current_folder

so that I can copy these files to the folder named the current date with no success

goumba · 12-20-2016, 11:56 AM

Code:

current_folder="$(date +%Y%m%d)"
mkdir "${current_folder}"
mv files "${current_folder}"

trickydba · 12-20-2016, 12:30 PM

I tried this code to moves all files with an extension of ".xlsx" to a folder labelled with the current date with no success:

mv *.xlsx "${current_folder}"

What am I doing wrong?

trickydba · 12-20-2016, 12:34 PM

I also tried this:

mv *.xlsx /export/home/eric/reports/${current_folder}

with no success. The files and the folder are in the same folder

I tried putting double quotes in too: mv /export/home/eric/reports/*.xlsx /export/home/eric/reports/"${current_folder}"

I get the error:

mv: '/export/home/exg85/reports/file_20161220.xlsx' ande '/export/home/exg85/reports/file_20161220.xlsx' are the same file.

But I specified to move the file to a folder labelled with the current date

trickydba · 12-20-2016, 12:46 PM

Also tried mv *.xlsx "${current_folder}" with no success

trickydba · 12-20-2016, 01:53 PM

Got it working, this is the code:

mv *.xlsx "${current_folder}"

Thx to all that have helped!!!