Shell Programming and Scripting

I have a bunch of files, they have spaces! I am working in windows 7, but I am hoping I could install and use cygwin or some other unix platform to rename my files (suggestions welcome).

The files are named:

Wind Attn Vol - 474.wrl
Wind Attn Vol - 475.wrl
Wind Attn Vol - 476.wrl etc..

I want the digits to be incremented by 60


Wind Attn Vol - 534.wrl
Wind Attn Vol - 535.wrl
Wind Attn Vol - 536.wrl etc..

All suggestions are greatly appreciated.

Hi,
Yes you can do with cygwin but dont forget to install necessary binaries like find,awk,perl, ssh while installing..
Try this untested code,

Code:

find /home/dir -name "*.wrl" |awk -F"[ .]" '{gsub(/ /,"\ ");ori=$0;$5=$5 60;print "mv ",ori,$0;}' |sh

First of all remove the last 'sh' command and see how the mv command printed in the screen. If its fine then execute with this whole command.
I assuming your directory names doesnt have any space and dot(.).
Cheers,
Ranga:-)

It has no chance of working, unless you quote the argument to -F.

Regards,
Alister

Yes thanks for pointing out. I have updated in my previous post.
Cheers,
Ranga:-)

If I understood the request correctly, I think the person submitting this request wants something more like:

Code:

ls *.wrl | awk '/[0-9]+/ {
        pos=match($0,"[0-9]+")
        val=substr($0,pos,RLENGTH)
        printf("mv \"%s\" \"%s%d%s\"\n",
                $0,substr($0,1,pos-1),val+60,substr($0,pos+RLENGTH))
        }'

which should show the commands to be executed. If the resulting commands are what is wanted, then pipe the output of the above through sh (or your favorite shell).

As it is in windows 7, you can use vbscript to rename the files

1) change the folder name
2) save the script as rename.vbs
3) open the command prompt and goto the script folder
4) execute the script by cscript.exe rename.vbs
5) Check the output ( it will just display the old & new file name )
6) If you are ok with the output, then remove the ' from 'objFSO.MoveFile and run it once again.

Code:

 
Dim WshShell, oExec 
Set WshShell = WScript.CreateObject("WScript.Shell") 
Set objFSO = CreateObject("Scripting.FileSystemObject")
objStartFolder = "C:\\TEST"
Set objFolder = objFSO.GetFolder(objStartFolder)
Set colFiles = objFolder.Files
For Each objFile in colFiles
    startpos=instr(objFile.Name,"-")
 endpos=instr(objFile.Name,".wrl")
 Number=(Mid(objFile.Name,startpos+2,(endpos-(startpos+2))))
 Number=Number+60
 Fpart=Mid(objFile.Name,1,startpos)
 Spart=Mid(objFile.Name,(Len(objFile.Name)-3),4)
 newFileName=Fpart & " " & Number & Spart
 wscript.echo "OLD FILE : " & objFile.Name & "    NEW FILE : " & newFileName
 FileName = objStartFolder & "\\" & objFile.Name 
 newFileName = objStartFolder & "\\" & newFileName
 'objFSO.moveFile FileName, newFileName
Next

Thanks all for your elite comments. But unfortunately, I was just stuck with Windows 7 trying to get cygwin to work since cygwin has installation issues on Windows 7. I tried all day yesterday. Then I tried using LinuxConsole which creates a linux partition on windows, which I installed a long time ago, but for some reason it has issues with grub. But, I still did not give up, and am working to find a way to work on the linux/unix platform (any ideas?).

In the meanwhile, itkamaraj suggested a solution in Windows 7 platform. Thanks itkamaraj. Your code did work fantastically, but it spits out an error at the end - "Microsoft VBScript runtime error: Invalid procedure call or argument: 'Mid'". I just ignored this error since I got what I wanted for most part. But, when I had a slightly different file format, the code just fails with the error "rename.vbs(10, 2) Microsoft VBScript runtime error: Invalid procedure call or argument: 'Mid'"

The newfile format that I have is:

Wind Attn Coeff Tunnel - 474.wrl
Wind Attn Coeff Tunnel - 475.wrl
Wind Attn Coeff Tunnel - 476.wrl, etc.