Rename-Pairs and Wildcards

[Kinoss]

I have about 10,000 images that I need to rename. I have a list of part numbers and the numbers they need to be renamed to. However the filenames include a little extra information that makes Rename-Pairs more difficult.

030-612-001.tif
030-612-003.tif
030-612-007.tif
071-003-001.tif
090-192-007.tif

The first 7 characters (eg. 090-192) represent the part number and the last 3 represent a particular "view." I would like to only change the first seven characters and retain everything else. In my mind the command would be something similar to this:

030-612*|482795*

Is there a way to accomplish this I'm not thinking of. Much thanks to any help!

[Stefan]

I have about 10,000 images that I need to rename.
I have a list of part numbers and the numbers they need to be renamed to.
However the filenames include a little extra information that makes Rename-Pairs more difficult.

030-612-001.tif
030-612-003.tif
030-612-007.tif
071-003-001.tif
090-192-007.tif

The first 7 characters (eg. 090-192) represent the part number and the last 3 represent a particular "view."
I would like to only change the first seven characters and retain everything else.
In my mind the command would be something similar to this:

030-612*|482795*

Is there a way to accomplish this I'm not thinking of. Much thanks to any help!

Use e.g. MS Excel, Spread32 or Open/LibreOffice or any other spread sheet as g00gle docs/drive:
- export a list of all file names (with BRU or from DOS with dir /B > List.txt)
- open/paste them in Excel to A column
- In B column add a formula to copy only the first seven chars to B
- in column C paste your own list
- in column D add formula to merge B and C plus original extension into D
- in column E merge A & | & D
- export E as rename pair list.

See
http://img845.imageshack.us/img845/7416/utilizespreadsheettoren.png

Edit:
I realized you want it really as you wrote and not the ways i wanted to understood
So second try

- export a list of all file names (with BRU or from DOS with dir /B > List.txt)
- open/paste them in Excel to A column
- In B column add a formula to copy only the LAST 4 chars to B ( incl. dot and extension that are 8 sings from right. Then we want the left four signs only)
- in column C paste your own list
- in column D add formula to merge C and B plus original extension from A into D
- in column E merge A & | & D to get the rename pairs for BRU together
- export E as rename pair list. That is a plain text only file. Just use original notepad to be sure.


See
http://img6.imageshack.us/img6/7416/utilizespreadsheettoren.png

[Admin]

Stephan, you are a wizard! Fantastic!

[Stefan]

Thanks for feedback