On Wed, 19 Sep 2007 20:14:28 -0400, Ron Rosenfeld
wrote:

On Wed, 19 Sep 2007 17:59:04 -0500, Dick Kusleika wrote:

On Wed, 19 Sep 2007 12:24:02 -0700, Dave
wrote:

For example I could set a pattern of "[)(*&^]" how would I code it to
exclude those values?

.Pattern = "[^)(*&\^]"

Note the \ that precedes the second ^. The first ^ defines the character
sequence as negative and the \ escapes the second ^ so it's included in the
negative character sequence.

I don't believe there is any need to escape the ^ in VBScript. Both by
testing, and by documentation, it seems to be unnecessary.

http://msdn2.microsoft.com/en-us/library/ta6y6h4z.aspx

"If the caret character appears in any other position within the list, it
matches itself, that is, it has no special meaning. "


Ron: You're right. Mine was actually excluding the slash too. Thanks for
the correction.
--
Dick