Just as follow up... none of the suggestions worked. I used all the examples you both provided me.
It is giving me the same results: it capitalize the first letter, but removes the character (').
...meaning it will change 'round Midnight to Round Midnight (but does not place the ' apostrophe character in front). Not sure why.
I read the manual before writing. I had been putting it off for a few weeks and thought I would seek out advice.
I even tried to use the O'Bryan example on the sight. then i made a separate action thinking one of the other action groups were overwriting the title.
I'll keep working at it... but again just wanted to see if there was another way to get it work...
I can tell you now that mine works. see screenshot. i think you made a mistake somewhere copying the information across. i'll attach the action for you. place it in the actions folder. job done.
Action: Case Conversion
Field: ALBUM
Case conversion: Mixed Case
Words begin from/after any of: '
or
Action: Format Value
Field: ALBUM
Formatstring: $caps(%album%,'')
(you have to repeat ' here twice, because otherwise ' is interpreted as part of the formatstring syntax. '' are two apostrophes, NOT one quotation mark)
Of couse you will also get things like "O'Brian'S Partents Are'Nt Here" with these actions.