At 12:57 31/08/2014 -0500, Jim Byrnes wrote:
I have some cells that contain data like: (IBM) Ibm corporation. I
need to extract the stock symbol ie IBM. I thought I could use regex
to get (IBM) and then strip the parens. So far I have been unable to do so.
[...]
myRegex.SearchString = "\([A-Z]\)"
The pattern [A-Z] will match any single capital letter, so your
string will match (I) but not (IBM). You need something like
"\([A-Z]+\)" - where the "+" after the "[A-Z]" makes the combination
match one or more consecutive capital letters.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
