[ExcelVBA] Re: Help Needed in Regular Expression Pattern

 

Thanks - I'm trying to replace any group of multiple quotes, as in your example with any single character to replace the group.
So, like this:

'''''hello'''''
$hello$

--- In ExcelVBA@yahoogroups.com, Gary Morris <gwmorris@...> wrote:
>
> I can't determine what it is you are after. You say that you are
> trying to replace"all multiple occurrences of single quotes", so
> does that mean like a cell entry like: '''''''too many quotes'''''''?
> And then, what are you replacing the group of quotes with?
> Double quotes? Are you wanting to consolidate them to just
> one quote, as in the above: 'too many quotes' would then be
> the result? Without enough information, not many people can
> or will even try to help. Maybe you could post an example
> with before and after or something...
>
>  
> G.
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 9
• New Files 1

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

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

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___