Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

reReplace help to fix first lower case after (

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]")

Open in new window


but this does not work.

Can anyone help me understand the correct syntax to use?
0
ShanghaiD
Asked:
ShanghaiD
1 Solution
 
Tomarse111Commented:
This will give you title case:

#rereplace( v, "\b([a-z])", "\U\1", "ALL")#
0
 
ShanghaiDAuthor Commented:
Thank you for the quick response!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now