[SOLVED] Append date to different named files

trickydba · 01-09-2017, 03:12 PM

I realize that I opened a thread concerning this, but it wasn't clear. Let's say I have three files:

cat.xlsx
dog.xlsx
bird.xlsx

and I wanted them to look like this:

cat_01092017.xlsx
dog_01092017.xlsx
bird_01092017.xlsx

How can I go about doing this? All files will have a .xlsx extension

With my current code:

file1=DOG_BROWN.xlsx; cfile1=DOG_BROWN; current_time=$(date "+_%Y%m%d.xlsx"); newfile1=$cfile1$current_time; mv $file1 $newfile1

It's not as dynamic as I would like it cause I have to put in manually every new file that get generated.

MensaWater · 01-09-2017, 03:43 PM

If you put it in a script named say "addtime.sh" with contents like:

Code:

file1=$1
basefile1=$(echo $file1 |awk -F. '{print $1}')
current_time=$(date "+_%Y%m%d.xlsx")

mv $file1 ${basefile1}${current_time}

You make the script executable then run it against any file:
./addtime.sh bird.xlsx

Alternatively you could look for files in the directory in your script and do a for loop:

Code:

for file1 in $(ls *[a-z].xlsx)
do 
basefile1=$(echo $file1 |awk -F. '{print $1}')
current_time=$(date "+_%Y%m%d.xlsx")

mv $file1 ${basefile1}${current_time}
done

The latter assumes your files are always named with an alpha character followed by .xlsx so would exclude any files you'd already renamed.

ondoho · 01-09-2017, 03:55 PM

Code:

#!/bin/bash
now="$(date +%Y%m%d)
for i in *.xlsx; do
    mv "$i" "${i%.xlsx}_${now}.xlsx"
done

you're welcome.

edit:
oh, someone else managed to whip up something more elaborate meanwhile.

Sefyir · 01-09-2017, 04:12 PM

Obligatory one-liner. You can use this for any filetype (instead of just .xlsx) and appears to be somewhat reliable. Only the extension should be cut off / reattached. Remove the echo once you establish it is working correctly.

Code:

datestampfile() { for i in $@; do echo mv "$i" "${i%.*}_$(date +'%Y%m%d').${i##*.}"; done; }

Usage:

Code:

datestampfile file.mp4
datestampfile *
datestampfile *.mp4

Example output:

Code:

mv foobar.ext foobar_date.ext
mv filez.10.mov filez.10_20170109.mov
mv filez.10.mp4 filez.10_20170109.mp4
mv filez.10.xlsx filez.10_20170109.xlsx
mv filez.11.mov filez.11_20170109.mov
mv filez.11.mp4 filez.11_20170109.mp4
mv filez.11.xlsx filez.11_20170109.xlsx
mv filez.12.mov filez.12_20170109.mov
mv filez.12.mp4 filez.12_20170109.mp4
mv filez.12.xlsx filez.12_20170109.xlsx
mv filez.13.mov filez.13_20170109.mov
mv filez.13.mp4 filez.13_20170109.mp4
mv filez.13.xlsx filez.13_20170109.xlsx
mv filez.14.mov filez.14_20170109.mov
mv filez.14.mp4 filez.14_20170109.mp4
mv filez.14.xlsx filez.14_20170109.xlsx
mv filez.15.mov filez.15_20170109.mov

trickydba · 01-10-2017, 06:30 AM

Ya'll are freakin AWESOME!!!!!!!!!!!!!!!!!!!!! Thank you sooooooo much!!! Fast too!!! 8.))

trickydba · 01-10-2017, 06:31 AM

All above codes resolve my issue. What do I say to anyone with the same issue that reads this thread...........take yer pick!!! lol

trickydba · 01-10-2017, 06:32 AM

@Mensawater............hey neighbor I'm in the A too!!!!

trickydba · 01-10-2017, 06:35 AM

@Mensawater............... Can the files already have a .xlsx extension or must it be removed first?

trickydba · 01-10-2017, 06:50 AM

@Mensawater....I got an error using your second code. All I did was copy and pasted it in, was I supposed to edit your code?

trickydba · 01-10-2017, 07:09 AM

@Mensawater...............your 1st code suggestion did not add the date to any files. I don't know if it matters but in some of the files they have an underscore

rtmistler · 01-10-2017, 07:14 AM

Why have you not tried to use the rename command?:

Code:

$ ls
bird.xlsx     cat.xlsx     dog.xlsx
$ rename 's/.xlsx/_01092017.xlsx/' *.xlsx
$ ls
bird_01092017.xlsx     cat_01092017.xlsx     dog_01092017.xlsx

trickydba · 01-10-2017, 07:29 AM

@rtmistler........ cause I'm trying to make it more dynamic

pan64 · 01-10-2017, 07:32 AM

what do you mean by more dynamic? rename is definitely a very flexible tool, I think you can do almost anything you need in one line.

rtmistler · 01-10-2017, 07:34 AM

Quote:

Originally Posted by trickydba

@rtmistler........ cause I'm trying to make it more dynamic

Quote:

Originally Posted by trickydba

I realize that I opened a thread concerning this, but it wasn't clear. Let's say I have three files:

cat.xlsx
dog.xlsx
bird.xlsx

and I wanted them to look like this:

cat_01092017.xlsx
dog_01092017.xlsx
bird_01092017.xlsx

How can I go about doing this? All files will have a .xlsx extension

With my current code:

file1=DOG_BROWN.xlsx; cfile1=DOG_BROWN; current_time=$(date "+_%Y%m%d.xlsx"); newfile1=$cfile1$current_time; mv $file1 $newfile1

It's not as dynamic as I would like it cause I have to put in manually every new file that get generated.

Then you should describe your total requirements more clearly. Besides a few compliments to those who have offered their solutions, you've not updated your problem description. All it says is that you do not wish to put in every file manually.

Noticing what pan64 added just as I was typing my response. Same point.

trickydba · 01-10-2017, 07:36 AM

@rtmistler......I apologize I've only been on this site about 2-3 months so I'm still working to get the hang of things