I have many strings of company names -- "Big Consulting Co (china) Ltd" as an example. Note that the first letter after the "(" is lower case -- but should be upper case -- ie: "Big Consulting Co (China) Ltd".
I've tried to fix this using reReplace, as follows:
reReplace(thisString, "\([a-z]", "\([A-Z]")
but this does not work.
Can anyone help me understand the correct syntax to use?