View Single Post
  #17  
Old April 19th, 2009, 03:36 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 Sun, 19 Apr 2009 05:47:47 -0700 (PDT), Luciano Paulino da Silva
wrote:

3 Right side of K or R if P is Right to K or R; except after K
in CKY, DKD, CKH, CKD, KKR; after R in RRH, RRR, CRK, DRD, RRF, KRR

AAKASASRAAAKASASKPASASASRPSASDFCKYDSADSDKDASCKHSG AHSACKDFHASFKKRGHAHGRRHGSAHGSAHRRRFSDAGFSCRKASDRDR RFKRRS

AAK
ASASR
AAAK
ASASKPASASASRPSASDFCKYDSADSDKDASCKHSGAHSACKDFHASF KKRGHAHGRRHGSAHGSAHRRRFSDAGFSCRKASDRDRRFKRRS

9 Left side of D, Right side of K

ASASADSASASKASSASASHASASKSASASDSAAS

ASASA
DSASASK
ASSASASHASASK
SASAS
DSAAS

12 Right side of D or E except if P is Right to D or E, or if E
is Right to D or E

ASADSSASASAESASASADPASASASAEPASAASDEASASASAEESASA S

ASAD
SSASASAE
SASASADPASASASAEPASAASDEASASASAEESASAS



I think these will do: (The others will have to wait, if you can't figure it
out).

Rule3:

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

Rule9:

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

Rule12:

"([^DE]|[DE][EP])+[DE]?|[DE]"
--ron