How to find only certain ranges of individual letters in a row in filenames? etc
Posted: Thu Dec 29, 2022 12:39 am
Hello, could someone please help me with a couple related searches I'm trying to accomplish?
I have many mp3 files on my computer whose filenames over the years I have put a bunch of g's in a row in, in order to indicate that these mp3s
have me playing guitar in them. I want to organize the files so they only have 20 g's in a row in them from now on. But currently they have somewhere between 10 and 27 g's in a row in them.
Here's the searches I'd like to accomplish:
all files with exactly 20 g's in a row in their filenames, for example:
2201108_abc123ggggggggggggggggggggabc123.mp3
all files with ten or more g's in a row in their filenames, but not filenames with exactly 20 g's in a row in their filenames, for example:
search result would show filenames like these:
2201108_abc123ggggggggggabc123.mp3 (10 g's in a row)
2201108_abc123gggggggggggggggabc123.mp3 (15 g's in a row)
2201108_abc123gggggggggggggggggggggggggggabc123.mp3 (27 g's in a row)
but would not show filenames like these:
2201108_abc123ggggggggggggggggggggabc123.mp3 (20 g's in a row)
2201108_xyz98_gggggggggggggggggggg_yz987.mp3 (20 g's in a row)
Maybe some usage of Search> Match Whole Word?
I don't know how to use regular expressions yet, but maybe some formula with those would do it?
Thanks for any help with this.
;;;;;;;;;;;
Edit:
Also, a search that would show, for example, all files with only exactly 3 g's in a row in the filenames, like these:
2201108_abc123gggabc123.mp3 (only exactly 3 g's in a row)
xyz321_ggg.mp3 (only exactly 3 g's in a row)
thus not these
2201108_abc123gggggggggggggggggggggabc123.mp3 (more than 3 g's in a row)
xyz321_ggggggggg.mp3 (more than 3 g's in a row)
;;;;;;;;;;;
I have many mp3 files on my computer whose filenames over the years I have put a bunch of g's in a row in, in order to indicate that these mp3s
have me playing guitar in them. I want to organize the files so they only have 20 g's in a row in them from now on. But currently they have somewhere between 10 and 27 g's in a row in them.
Here's the searches I'd like to accomplish:
all files with exactly 20 g's in a row in their filenames, for example:
2201108_abc123ggggggggggggggggggggabc123.mp3
all files with ten or more g's in a row in their filenames, but not filenames with exactly 20 g's in a row in their filenames, for example:
search result would show filenames like these:
2201108_abc123ggggggggggabc123.mp3 (10 g's in a row)
2201108_abc123gggggggggggggggabc123.mp3 (15 g's in a row)
2201108_abc123gggggggggggggggggggggggggggabc123.mp3 (27 g's in a row)
but would not show filenames like these:
2201108_abc123ggggggggggggggggggggabc123.mp3 (20 g's in a row)
2201108_xyz98_gggggggggggggggggggg_yz987.mp3 (20 g's in a row)
Maybe some usage of Search> Match Whole Word?
I don't know how to use regular expressions yet, but maybe some formula with those would do it?
Thanks for any help with this.
;;;;;;;;;;;
Edit:
Also, a search that would show, for example, all files with only exactly 3 g's in a row in the filenames, like these:
2201108_abc123gggabc123.mp3 (only exactly 3 g's in a row)
xyz321_ggg.mp3 (only exactly 3 g's in a row)
thus not these
2201108_abc123gggggggggggggggggggggabc123.mp3 (more than 3 g's in a row)
xyz321_ggggggggg.mp3 (more than 3 g's in a row)
;;;;;;;;;;;