View Single Post
  #14  
Old April 19th, 2009, 01:14 PM posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default Macro to apply parsing rules for strings and list the substrings

On Sat, 18 Apr 2009 20:04:16 -0700 (PDT), Luciano Paulino da Silva
wrote:

I`m having some problems with rules 3, 9, 12, 13, 14, 15, 16, 20.


You didn't give any examples of what the results would be of these rules when
applied to a target string. By that I mean to do, as you did in your initial
posting, to give an example of the input string, and what you expect as output.

That makes it more difficult to debug.

But try this:

Rule 3:

"(CKY|DKD|CKH|CKD|KKR|RRH|RRR|CRK|DRD|RRF|KRR|[^KR]|[KR]P)+[KR]?|[KR]"

Rule 9:

"D?[^KD]+K?|[KD]"

-------------------------------------

For the other rules, give some examples (and also for these rules if the
results are unexpected).

------------------------------------
--ron