Change date format in filenames

Question

I am receiving emails, the filename format is this (It is Unix format for date + .report-server)

1509106656.32538_1.report-server

Now I have several emails. I want to format all file names with new date time format like this.

dd-mm-yyyy.report-server

Why do you want dd-mm-yyyy? See mandatory xkcd comic about ISO 8601 :-) — egmont, Jan 10 '18 at 15:18

score 1 · Accepted Answer · answered Jan 10 '18 at 12:12

How about this:

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

This loops over the .report-server files in the current directory and for every file prints a line like

mv 1509106656.32538_1.report-server 27-10-2017.report-server

where you can check the file name. If it does what you want, simply remove echo from the command and run it to perform the renaming.

Be careful! If you end up having multiple files with the same date mv will (by default) silently overwrite the first ones. If you want to preserve the (presumably unique) .32538_1 part, change ${i##*.} to ${i#*.} in the command. If you want mv to ask before overwriting files, add the -i option.

Its working thanks. i change mv to cp . And yes i noticed that but i am receiving email per day, it will work fine. — DaviD, Jan 10 '18 at 12:26
@DaviD If you want to have the files sorted correctly I recommend using yyyy-mm-dd format instead – replace %d-%m-%Y with %F for that. — dessert, Jan 10 '18 at 14:02

Mukesh Sai Kumar · Answer 2 · 2018-01-10T12:29:06.117

1

You can use the following script as a hint:

#!/bin/bash
for i in *.report-server; do
    timestamp=$(echo $i | cut -d. -f1)
    output_date=$(date +'%d-%m-%Y' -d @$timestamp)
    mv "$i" "${output_date}.report-server"

edited Jan 10 '18 at 12:29

answered Jan 10 '18 at 12:13

Mukesh Sai Kumar

743

Yes there was error extra operand ‘@1507285570’ – DaviD Jan 10 '18 at 12:27
@MukeshSaiKumar +1 You're welcome! – dessert Jan 10 '18 at 12:40

score 1 · Answer 3 · answered Jan 10 '18 at 13:34

Here's a way to do it using perl-based rename or prename (essentially a duplicate of How can I batch convert folder names from one date format to another, with different format specifiers):

$ rename -n -- '
  BEGIN{use Time::Piece};
  s/(\d{10})\.\d{5}_1/Time::Piece->strptime($1, "%s")->strftime("%d-%m-%Y")/e
' *.report-server
rename(1509106656.32538_1.report-server, 27-10-2017.report-server)

Remove the -n (or change to -v if you want verbose output) when you are happy that it is doing what you want.

Change date format in filenames

3 Answers3