Group w/ same numbers, different letter

[awakeimages]

Hi - I'm hoping this isn't something easy that I've missed... Thanks in advance for the help.

Original files:

Image_1
Image_2
Image_3
Image_4
Image_5

I want:

Image_1a
Image_1b
Image_1c
Image_2a
Image_2b
...etc.

[Stefan]

Only with a little work around via a script or a spreadsheet as Excel or Spread32
to create a OldName|NewName list for BRUs "Renaming From A Text File" feature:

In Excel:

Column A (your original file names
image A_1
image Vac_2
imaging_3
image Test_4
image Bird_5


Column C (drop trailing "_1")
=LEFT(A1;LEN(A1)-2)
<copy the above formula down the rows>

Results in:
image A
image Vac
imaging
image Test
image Bird


Column E (create 1,1,1,2,2,2,3,3,3,4,4,4,... sequence)
1
1
1
=G1+1
=G2+1
=G3+1
<copy the above three formula down the rows>

Results in:
1
1
1
2
2
2
3
3
3
4
4
4
5
5
5



Column H (create a,b,c,a,b,c,a,b,c,... sequence)
a
b
c
<copy the above three cells down the rows>

Results in:
a
b
c
a
b
c
a
b
c
a
b
c
a
b
c


Column J (Join all together)
=A1&".jpg"&"|"&C1&"_"&G1&H1&".jpg"
<copy the above formula down the rows>

Results in:
image A_1.jpg|image A_1a.jpg
image Vac_2.jpg|image Vac_1b.jpg
imaging_3.jpg|imaging_1c.jpg
image Test_4.jpg|image Test_2a.jpg
image Bird_5.jpg|image Bird_2b.jpg



Now Copy the Column J and save as Text file for BRUs "Renaming From A Text File" feature:


In BRU use the "Renaming From A Text File" feature.

Code: Select all

            1. Select the folder which contains the objects you wish to rename.
            2. Select the files you wish to process (use CTRL or SHIFT to select multiple files).
            3.  Enter the renaming criteria.
                 Here, click the Import option on the File menu and load your file.
                 If the file is valid then you will see the "new name" column reflecting the contents of the text file.
            4. Hit the Rename button. (This button is not enabled unless you have selected one or more files/folders to rename!)


More about Excel work >>>
http://www.bulkrenameutility.co.uk/forum/viewtopic.php?t=1271&f=3
Board index ‹ Bulk Rename Utility ‹ Regular Expressions >> renaming avi files to match srt files...

[awakeimages]

Wow! Thanks so much!