I have a custom action list that replace various stuff such as:
FIELD: _ALL
On > on
Is > is
etc ....
my problem is some song titles have these words in the beginning of them so how can I use scripting functions to not have the the utmost left character be changed
If the replace is targeted at single words within a string, you can simply add a leading blank to the words - at the beginning of a field there should not be a blank.
You have to judge if the replacements are a word of their own or part of a word.
So, to replace the single "A" to "a" would mean that you look for " A " and replace it with " a ".
If the "a" is the start of a word (like "and") then you would search for " A" and replace it with " a".
Common to these examples is that the sought-after letter combination has a " " (=blank) in front - if the letter combination is found at the beginning of a field then there is no blank in front.
Clear enough?
so i'm still in a slump about this. What you mentioned earlier is perhaps the best fit for me, it's just I don't think there is a case conversion specific code for only specific character modification.