I need help on renaming files using awk or sed please

Question

I need help on renaming files using awk or sed please

HHG (TechnicalUser)

(OP)

22 Oct 07 06:01

I have a list of files with a file structure as below:-

07(year)+11(month)+19(day of the month)+24(hour)+10(minutes)+55(seconds)+afilenameanylength.txt

I need to rename the file so I get rid of the 07(year)+11(month)+19(day of the month)+24(hour)+10(minutes)+55(seconds) and rename it to afilenameanylength.txt
e.g ls *.txt | awk '{print "mv" $1, substr($1,13,25)}'

Can anyone help please, it will be most appreciated.

Many thanks in advance.

p5wizard (IS/IT--Management) · Answer 1 · 2007-10-22 08:08:27

This?

CODE

ls *.txt | awk '{print "mv", $1, substr($1,13)}'|sh

but it's kind of dangerous because you may end up overwriting a lot of files that once had a unique name...

Therefore, a trial run:

CODE

ls *.txt | awk '{print "echo mv", $1, substr($1,13)}'|sh

HTH,

p5wizard

columb (IS/IT--Management) · Answer 2 · 2007-10-22 08:10:55

It's not quite what you asked ffor but..

CODE

#!/bin/ksh
for file in *.txt
do
mv $file ${file##[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]}
done

But I'm sure someone will come up with a better version

Ceci n'est pas une signature
Columb Healy

HHG (TechnicalUser) · Answer 3 · 2007-10-22 09:14:33

thanks for this all.

I now get this

echo cp 000008522130127cl 000008522130127cl .csv

I need to get rid of the space between second file name and the .csv

any clues.

I used this syntaxls * | awk '{print "echo cp", $1, $1,".csv"}'> filename

so it reades:-

echo cp 000008522130127cl 000008522130127cl.csv

p5wizard (IS/IT--Management) · Answer 4 · 2007-10-22 09:19:41

so, get rid of the last comma between $1 and ".csv" ...

HTH,

p5wizard

Come Join Us!

Posting Guidelines

Jobs

I need help on renaming files using awk or sed please