StrataFrame Forum / General .NET Discussion / .NET Forums / Need help creating RegEx expression... / Latest Posts

RE: Need help creating RegEx expression...

Ben Chase — Thu, 17 Aug 2006 14:27:33 GMT

Try this:

\binto\b.*?#(\w*)\b

However, use RegexOptions.SingleLine instead of MultiLine.

RE: Need help creating RegEx expression...

StarkMike — Thu, 17 Aug 2006 14:21:31 GMT

Thanks guys! This is awesome information... I've submitted the PO for the RegExBuddy.

The expression wont find the INTO #TEMP on its own line... it'll only find the one thats on the same line. What do I need to change?

RE: Need help creating RegEx expression...

Ben Chase — Thu, 17 Aug 2006 14:05:04 GMT

RegexBuddy, we use it all the time :)

RE: Need help creating RegEx expression...

Ben Chase — Thu, 17 Aug 2006 14:02:33 GMT

I think it's only like $29 or something like that.

As for finding the INTO if it's on it's own line, no, you'll need to replace the first " " with a ( |$) or something like that.

RE: Need help creating RegEx expression...

Trent L. Taylor — Thu, 17 Aug 2006 14:00:02 GMT

This is a very long a deep topic. One thing I might suggest is purchasing a copy of RegExBuddy (http://www.regexbuddy.com/) which will allow you to create and test expressions within an editor. You can then take those expressions and import them over to .NET.

There is really no such thing as a "brief" explanation when it comes to RegEx. :w00t:

RE: Need help creating RegEx expression...

StarkMike — Thu, 17 Aug 2006 13:57:24 GMT

Thanks! Would you mind briefly explaining to me how you created that expression? I'm new to RegEx expressions and having a hard time understanding how they work.

The expression you created will find the INTO statement whether it is on a line by itsself or on one line with the rest of the SQL statement?

RE: Need help creating RegEx expression...

Ben Chase — Thu, 17 Aug 2006 13:49:32 GMT

System.Text.RegularExpressions.RegEx.IsMatch(myvalue, "into #(\w*?)( |$)", System.Text.RegularExpressions.RegexOptions.IgnoreCase Or System.Text.RegularExpressions.RegexOptions.Multiline)

The actual recular expression would be this:

into #(\w*?)( |$)

Make sure you use RegexOptions values so that the "into" will match "INTO" and so that the $ will match the end of a line.

Need help creating RegEx expression...

StarkMike — Thu, 17 Aug 2006 13:37:34 GMT

These are my examples:

SELECT *
INTO #TEMP
FROM TABLE

SELECT * INTO #TEMP FROM TABLE

I would like some help creating a RegEx pattern to find the word INTO followed by a space then a pound sign (#) then a wildcard for the temp table name then another space.

Thanks