The following is an example of the string of text which I have to work on:
Actual working examples of album titles are:
Cara Mia (wChorus & Mantovani & His Orchestra)
Rock And Roll Waltz (wThe Hugo Winterhalter)
The string of text that needs editing, usually appears in the TITLE, ARTIST and the _FILENAME fields.
There are the three constants in the aforesaid strings:
- The opening bracket
- The closing bracket
- The letter "w" that immediately follows the opening bracket.
The letter "w" appears in lower case, although there are exceptions which are capitalised. There is no space inbetween the "w" and the leters immediately following, until the closing bracket. The text following the "w" can also vary considerably in length and form.
I am seeking your assistance, please, for a filter to apply to locate those files that match the opening bracket plus the lower case "w" (OR capital "W") in the %title%, %artist% and %_filename% fields. My own efforts at this came adrift using this, for example, for the %title% field:
%title% MATCHES \(w
%title% MATCHES \(w[w]
Once the relevant files are found, what would be the best way to restructure the applicable string to this —
From: (wfrank) to (With Frank)
That is, capitalise the W that follows the opening bracket, followed by a space, and then capitalise the first letter directly following this space.
I did make a Format Value action group for the three abovementioned fields that looks like this, and it is working, but I want to know if it holds any pitfalls which I should be aware of: