Working with Regular Expressions

OdeToCode Links For July 4

OdeToCode Links — Mon, 04 Jul 2005 20:04:52 GMT

Here is an oldie but a goodie: Jason Antonelli describes the URL Rewriting strategies used for MSN...

re: Working with Regular Expressions

Chris Pritchard — Sat, 03 Sep 2005 03:17:07 GMT

Great article!! I found it quite usefull. Just to be picky the N of NXX can only be from 2 to 9. 800-098-3884 would be invalid as would 800-198-3884. I used to work on a local calling area application for a phone company :)

re: Working with Regular Expressions

Trevor Dwyer — Fri, 09 Sep 2005 16:27:23 GMT

I found this a particularly useful example.

re: Working with Regular Expressions

Bug? — Tue, 06 Dec 2005 11:34:43 GMT

Isn't there a minor bug in the first example.

Regex.Match(matchString.TrimEnd(null)).Success;

Suppose that then last line should have been

r1.Match...

re: Working with Regular Expressions

CraigH — Thu, 08 Dec 2005 18:58:31 GMT

Great examples and exactly what I've been looking for. I have a question regarding whether resource usage would become a problem when using RegExOptions.Compiled flag and passing a different matchString each time.

MSDN says the following about compiled regular expressions.

"However, generated MSIL cannot be unloaded. The only way to unload code is to unload an entire application domain (that is, to unload all of your application's code.). Effectively, once a regular expression is compiled with the RegexOptions.Compiled option, the .NET Framework never releases the resources used by the compiled expression, even if the Regex object itself is released to garbage collection."

re: Working with Regular Expressions

Balaji Ramachandran — Fri, 26 May 2006 17:14:19 GMT

I have been thinking of moving our regular expression matching process to SQL server and I found this article very useful on that.

re: Working with Regular Expressions

Tyler — Tue, 01 Aug 2006 23:50:11 GMT

Just trying to get this going but I don't know mcuh about CLR or UDF's. Any advice on how I can get a CLR to work that allows me to search a table of regular expressions and find the record that matches the dynamically provided input value?

Thanks!

Complex Expression Matching within SQL Server 2005

SQL Server — Wed, 26 Mar 2008 22:06:04 GMT

As it stands today complex expression matching within SQL Server 2005 is "possible" at best and a nightmare