CODEWITHSUNDEEP
bashrename
James Stewart
James Stewart

Reputation: 3

Bash - File name change Date + 1

I have around 500 files that I need to rename with the date the report represents. The filenames are currently:

WUSR1453722998383.csv
WUSR1453723010659.csv
WUSR1453723023497.csv

And so on. The numbers in the filename have nothing to do with the date, so I cannot use the filename as a guide for what the file should be renamed to. The reports start from 02/12/2014 and there is a report for every day of the month up until yesterday (09/04/2016). Luckily as well the filename is sequential - so 04/12/2014 will have a higher number than 03/12/2014 which will have a higher number than 02/12/2014. This means the files are automatically listed in alphabetical order.

There is however a date in the first line of the CSV before the data:

As at Date,2014-12-02

Now I've checked that I have all the files already and I do, so what's the best way to rename there to the date? I can either set the starting date as 02/12/2014 and rename each file as a +1 date or the script can read the date on the first line of the file (As at Date,2014-12-02 for example) and use that date to rename the file.

I have no idea how to write either of the method above in bash, so if you could help out with this, that would be really appreciated.

In terms of file output, I was hoping for:

02-12-2014.csv 03-12-2014.csv

And so on

Upvotes: 0

Views: 138

Answers (1)

alijandro
alijandro

Reputation: 12167

Is that the answer you need? Assume all the file are under current directory. Do some testings before you do the real operation. The condition is every date string at your cvs file is unique. There will be some files be overwritten otherwise.

#!/bin/bash
for f in *.csv
do 
    o=$(sed '1q' $f |awk -F"[,-]" '{print $NF"-"$(NF-1)"-"$(NF-2)".csv"}')
    # should we backup the file?
    # cp $f ${f}.bak
    mv $f $o
done

Upvotes: 1

Related Questions