Print

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

[wnossel]

My goal is to identify all songs with names containing an upper case letter following an apostrophe and to change this upper case letter into lower case.
For example "L'Enfance de l'Art" should become "L'enfance de l'art".
Using Clean File Properties to fix the capitalization to "upper case first word only" solves the problem for all instances except those in the first word. My example becomes "L'Enfance de l'art), properly fixing the second problem but missing the first one.

Now, a regular expression function like Regex([Name],/#^(.*)'([A-Z])(.*)#/,0,1) identifies the candidates for change.
However, I don't know how to tweak it in order to solve my problem. When referring to the second bracketed expression ([A-Z]), is there a way to make it lowercase? I tried using \l like in
=If(Regex([Name],/#^(.*)'([A-Z])(.*)#/,0,1),[R1]'\l[R2][R3],"")
but it does not work.

Any ideas or workarounds would be much appreciated. W.

[MrC]

if(Regex([Name], /#^(.*')([A-Z])(.*)$#/,0,1), [R1]FixCase([R2],4)[R3], [Name])