RegEx to parse something like this...

[R Avery]

Say i have text that has many tags which are enclosed within curly
braces. For example,

"asdlghjkshkg {HOHO} ghk48975 83y4, c98ty34 {NANA} fshdjh348679njc
{ASDF} jdgghkjwer 435"

Say I want to write a RegEx to extract all of these tags. I thought
perhaps something like "(?[^{]*){([^}]*)})+" might work, but it does
not seem to... strangely, it still matches the entire string, but i
cannot get it to properly return all of the submatches.

Any help would be appreciated.

 

[Guest]

Check out the answer to this question on Dec 20, 2004.

http://groups-beta.google.com/group...oup:microsoft.public.excel.*#6507ef0086240f46

HTH,
Gary Brown

 

[Daniel.M]

Hi,

This should populate your Matches collection with the proper strings (I don't
know what you do with your results afterwards).

Set regEx = CreateObject("VBScript.RegExp") ' Create a reg expr.
regEx.Pattern = "\{[^{]*\}" ' Set pattern.
regEx.IgnoreCase = True ' Set case insensitivity.
regEx.Global = True ' Set global applicability.
Set Matches = regEx.Execute(YourStringToProcess) ' Execute search.
' you can concatenate here

Regards,

Daniel M.

 

[R Avery]

Thanks.

Check out the answer to this question on Dec 20, 2004.

http://groups-beta.google.com/group...oup:microsoft.public.excel.*#6507ef0086240f46

HTH,
Gary Brown

:

Say i have text that has many tags which are enclosed within curly
braces. For example,

"asdlghjkshkg {HOHO} ghk48975 83y4, c98ty34 {NANA} fshdjh348679njc
{ASDF} jdgghkjwer 435"

Say I want to write a RegEx to extract all of these tags. I thought
perhaps something like "(?[^{]*){([^}]*)})+" might work, but it does
not seem to... strangely, it still matches the entire string, but i
cannot get it to properly return all of the submatches.

Any help would be appreciated.