#1 : 27/11-19 11:50
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.
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)
Is there a way of doing this please?
#2 : 27/11-19 17:09
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...
without selecting "Use regular expressions"
27/11-19 17:09 - edited 27/11-19 17:54