|
Oct 2018
11:47pm, 30 Oct 2018
3,295 posts
|
run free
Um's solution should work as well as a PivotTable
A macro is OTT
|
|
Nov 2018
5:38pm, 1 Nov 2018
588 posts
|
um
Not excel, but general windows file name manipulation ... (unless there is a forum for that?)
I have a whole bunch of photos ( D:PhotosYYYYMMfilename ... ) where YYYY is 2003 to 2018, and MM is 1 to 12.
I have the originals and modified names where I edited some photos. For some reason, up to 2015 I used to put the mod (eg crop, lev) in front of the file name, whereas since 2016 I put it at the back.
Is there an easy way by command or batch file to scan all directories and change (eg) all files matching "crop IMG_nnnn.typ" to "IMG_nnnn crop.typ" ?
Or any way to reduce the tedium of doing them manually, 1 by 1 ?
|
|
Nov 2018
5:47pm, 1 Nov 2018
1,987 posts
|
Elsie Too
There is a way. I had a way in my last job, but that was 3 years ago so I can’t remember the way.
I will wrack my brains and hopefully come up with it. Or someone else will...
|
|
Nov 2018
5:50pm, 1 Nov 2018
1,988 posts
|
Elsie Too
I’ve shocked myself by having a brain wave, look for an application called XYPlorer. I’m pretty sure there is a free version that can do it.
|
|
Nov 2018
7:01pm, 1 Nov 2018
589 posts
|
um
Thanks Elsie - have taken a look & downloaded XYPLorer ...
- only free for 30 days, but if it works, that should do ...
- struggling to see how to do the select & rename (simple replace and mass edit are OK, but can't yet see how to do the select and name change I want)
But will spend some time playing / testing - as least I have 30 days to try it.
|
|
Nov 2018
8:43pm, 1 Nov 2018
1,989 posts
|
Elsie Too
Sorry Um, I can’t remember the detail of how we used it.
Hope you can figure it out.
|
|
Nov 2018
9:01pm, 1 Nov 2018
7,669 posts
|
Markymarkmark
There is a DOS Rename command - you should be able to run it from the command prompt/shell.
Something like
RENAME "crop IMG_????.typ" "IMG_????crop.typ" - can't quite remember the correct use of quotes in this instance for Windows filenames, since MS DOS did't allow anything much beyone xxxxxxx.xxx as a filename format!
From memory there was an option that allowed you to have a "Y/N" option, in later versions of DOS.
Test it on a copy of a subset of the files!
|
|
Nov 2018
8:51am, 2 Nov 2018
590 posts
|
um
Hi Marky - have been using the rename in command prompt as the quickest way, file by file, so far.
But cannot get the wild card to work across the files to remove and add 'crop' correctly.
|
|
Nov 2018
10:33am, 2 Nov 2018
17,952 posts
|
flanker
Without some clever us of piping filenames into and out of environment variables and text manipulation you'll not be able to do the wildcard bit; there's no easy way i can think of to get the wildcard component from the source to destination part of the command.
You'd be better using PowerShell which has better handling of variables, pattern matching and regular expressions.
|
|
Nov 2018
10:35am, 2 Nov 2018
17,953 posts
|
flanker
or, I guess, you could create a text file of the pairs of names, by redirecting the output of dir and hacking that about, and then pipe it into the ren command.
It's a while since I've done this sort of thing and it's hard to test on a Mac 
|
