[SOLVED] Change appended date on filename

trickydba · 01-25-2017, 08:55 AM

I have this code:

Code:

# Define variables
current_date=$(date "+%m%d%Y")
windows_folder="/dir/home/dir/reports/dir/dir/$current_date"

# Make folder
mkdir -p "$windows_folder"

#Copy all .DAT files to current dated folder in MDM folder
cp *.DAT /dir/home/dir/reports/dir/dir/$current_date

# Append current date to all files, move files to Windows shared folder
for file1 in *[a-z].xlsx
do
  mv "$file1" "$windows_folder/${file1%.*}${current_date}.xlsx"
done

That sends all files with an extension '.xlsx' to a folder dated with today's date. Example, in folder '01292017' are several files like this: TODAY_REPORT01292017. I like the way the folder is named with the current date (01292017), but I would like the files to be as such 'TODAY_REPORT_01292017'. How is this possible?

TenTenths · 01-25-2017, 09:02 AM

Change this:

Code:

mv "$file1" "$windows_folder/${file1%.*}${current_date}.xlsx"

To this:

Code:

mv "$file1" "$windows_folder/${file1%.*}_${current_date}.xlsx"

grail · 01-25-2017, 09:14 AM

I feel you did not make much of an attempt to solve this on your own. You need to write a smaller play script and play with the variables so you can better understand what limitations there might be.

Another thing you might consider for dates when creating folders or appending to similarly named files is that if you use the format 'yyyymmdd' it can actually be sorted for you easily

trickydba · 01-25-2017, 09:19 AM

@grail.........actually I have tried several attempts to resolve this issue. If any would have solved my issue I would have posted it. I apologize for not posting my attempts. I will be sure to do it in the future.

pan64 · 01-25-2017, 09:20 AM

there was another thread: http://www.linuxquestions.org/questi...es-4175597103/ with solution(s). It looks quite similar.

trickydba · 01-25-2017, 09:25 AM

This code has resolved my issue:

Code:

mv "$file1" "$windows_folder/${file1%.*}_${current_date}.xlsx"

Thank you for everyone's help!!