VBA Regex - How to match anything except a specific string?

Question

Sorry if the answer was out there somewhere. I did my research but couldn't find it.

I want to build a regular expression pattern that will match a line in the following format:

Begins with the word "sccp"
Followed by a space
Followed by anything except "ccm group"

I know that ^ in square brackets means "except for any of the characters". How do I exclude a phrase instead of single characters? Obviously, the pattern below didn't do what I wanted:

^sccp [^ccm group]

Thanks!

Callum Watkins · Accepted Answer · 2018-05-26 18:19:15Z

1

You should be able to use ^sccp (?!ccm group) or ^sccp (?!ccm group).* which uses a negative lookahead to assert that the phrase "ccm group" does not come after the space. Try it here.

If "sccp " should not match (i.e. nothing after the space), then use ^sccp (?!ccm group).+.

Information on the negative lookahead can be found here.

edited May 26, 2018 at 18:19

answered May 26, 2018 at 18:07

Callum Watkins

3,0204 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Regex - How to match anything except a specific string?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related