Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Peter_T]

Hi all - I'm sorting out some old photos that have descriptive filenames that I have used to fill in tags, but they are all in the form of:

AlphaBravoRomeo001

And I'd very much like to magically have them reformatted to:
Alpha Bravo Romeo 001

Or even:
Alpha Bravo Romeo001 (i.e. leave numbering out of this if that's easier)

Anyone know how that might be done?

[zybex]

Do all words always start with a Capital letter?
Are you OK that names like "NASATour" would be split like "N A S A Tour" ?

[Peter_T]

Good question I hadn't thought of all caps - I did a quick scan and I only see a few place abbreviations here and there so I'd be happy to live with the odd "N A S A" here and there.

[zybex]

OK then:
- select a few files
- press F6 to open the Rename tool
- select "Rename" on the first dropdown, de-select all checkboxes EXCEPT "Filename"
- Enter this rule:

Code: [Select]

replace(regex(FileName(,0),/#(\d+|[A-Z][^\dA-Z]*)#/,-2,1),;,/ )- Check the PREVIEW on the right to make sure it's fine, then click OK

If it goes well then you can do more files. Pay attention to files that don't follow your pattern of UppercaseWords001, because this expression will not work well with filenames containing symbols or outside of this pattern.

[zybex]

Note that this will change the actual filename on disk - if you just want to change the [Name] field visible on MC, then this is the wrong way.

[Peter_T]

Thanks for the quick response - I was hoping to change the tags only... sorry I should have made that clear.  I tried playing with your regex code in the tagging field, replacing 'filename' with 'Name' or with '[Name]' but no dice. 

I've already renamed my files, I guess I could use the tags to revert them back, then use the code, then rename them to match my new norms for naming... unless this code can be easily changed to work on a tag?

[zybex]

To fix the [Name], try setting it to:

Code: [Select]

=replace(regex([Name],/#(\d+|[A-Z][^\dA-Z]*)#/,-2,1),;,/ )
You can add this code as a new Expression Column just to test it out. Just right click on any column header and select "Add Expression Column".

[Peter_T]

Brilliant!  Thank you!!