Help renaming not fully sequential files

Advanced Renamer forum
#1 : 27/11-19 11:50
Abby
Abby
Posts: 1
This is my first time using advanced renamer so I need some help!!

My files (photos) are not fully sequential (taken from Excel workbooks where some pages had photos and some didn't.

Sheet1_Picture 1.JPEG
Sheet5_Picture 1.JPEG
Sheet5_Picture 2.JPEG
Sheet 6_Picture 1.JPEG

etc down to Sheet 93. Some sheets have up to 5 photos

I need them to be renamed as such: (Where Sheet 1 is 101815)

101815_1.JPEG
101819_1.JPEG
101819_2.JPEG
101820_1.JPEG

Is there a way of doing this please?


27/11-19 11:50
#2 : 27/11-19 17:09
David Lee
David Lee
Posts: 315
You can do this in two steps: first renumber "Sheet" by adding 101814, then remove the text.

1. Add a "Renumber method"...
Number position: 1
Change to: Relative to existing number
Number difference: 101814

2. Add a "Remove pattern" method to the same batch...
Pattern: Sheet ?|Picture
Use regular expressions: √

Step 2 assumes that the space in "Sheet 6" was intentional
If it was a mistake and the Sheet numbers never contain spaces then all you need is...
Pattern: Sheet|Picture
without selecting "Use regular expressions"


27/11-19 17:09 - edited 27/11-19 17:54
#3 : 20/12-19 15:42
MirandaBHarbin
MirandaBHarbin
Posts: 4
I am glad I have found your post and I was expecting the answer in your post and I got it. Actually, I was also looking for the same answer which you have posted in your post. And if you need any help regarding any essay assignment, then you can visit to the https://ukessay.com/assignment-writing-service website. Over here you find the best essay writer.


20/12-19 15:42
#4 : 15/01-20 10:11
JudyTBoyd
JudyTBoyd
Posts: 3
Hello, thanks for answering him because I am also searching for this. I also want to change name of few photos but I don't know how can I change them. Then I have found your post in which you are asking about the same question. And I am glad you have also got an answer and so do I. If anyone here wants to play casino games or interested in playing online casino games through which they can earn money then you can visit https://icasinoreviews.info/lucky-nugget-nz/ website. I also love to play real money making games over there.


15/01-20 10:11