Regular expression to convert case to Case, with exceptions


Any idea how best to implement a regular expression or action to convert all words in all fields to "First Letter Caps" (other than the following [a, an, the, and, but, or, as, at, by, for, in, of, on, to], unless they are first word in the string)?


I think I've solved it, thx.

Field: _ALL
RegEx: \s(a|an|and|as|at|by|but|for|in|of|on|or|out|the|to)(?=\s)
Replace matches with: $lower($0)

If you combine that with a Mixed Case Conversion action you pretty much end up with artist names, song titles and filenames formatted just how I like them :slight_smile: