Regex for scanning errorlog

Question

 I want to match a string for couple of words for regex in my sql server error log

warning|failed|error|access_violation

Now, I want to add certain exception to this regex expression -

1. I want to match all string with "failed" but not "login failed"

2. I want to match all string with error but no "errorlog"

Thanks,

Shiju Samuel

Answer 1

On Wed, 29 Aug 2012 04:56:29 +0000, Shiju Samuel wrote:

 

>

>

> I want to match a string for couple of words for regex in my sql server error log

>

>warning|failed|error|access_violation

 

>

>Now, I want to add certain exception to this regex expression -

>

>1. I want to match all string with "failed" but not "login failed"

>2. I want to match all string with error but no "errorlog"

 

Word boundary and look arounds will do this:

 

\b(warning|(?<!login\s+)failed|error|access_violation)\b

 

---

Ron

Answer 2

Thanks Ron!!