Search and Replace VBA Challenges

[yonyon7]

Hi,


I have 2 search and replace vba challenges I'm struggling with:

1. Replace based on partial string – replacing whole word based on partial string. Using "str* " is not always useful since line breaks are ignored that way, and wildcards aren’t useful when implementing with strcomp (selection.replace is a more limited option..) – for example, replace words containing @ (or "http" or anything else..) with nothing (word can be first, last, followed by ","/line break/…, etc.)
2. Repetitive characters - replacing repetitive characters (such as "ffff") with only two instances of the text. So "ffffff" and "fff" and "ff" are all replaced with "ff". the thing is – it should be generic to apply to all characters ("fffff", "rrrrrrr", "aaa"…)

Thanks!!
Yon

 

[NMadson]

Have you looked at Regular Expressions ("RegEx") and VBA? It's a powerful tool for the kind of manipulation you're talking about. I don't know enough myself to respond to your specific questions. I've only used RegEx once to solve one specific problem. It did take a while to get the syntax correct.

HTH,
Nolan

 

[yonyon7]

Thanks Nolan,

Seems like a wise direction to investigate.

Thanks!
Yon