Using Find and Replace with Regular Expressions to match one word and exclude another

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Using Find and Replace with Regular...

Using Find and Replace with Regular Expressions to match one word and exclude another

Rate Topic

Display Mode

Topic Options

Author

Message

tskelley

Posted Wednesday, December 12, 2012 11:36 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 6:34 AM
Points: 33, Visits: 758

I am using Find and Replace in SSMS to search for any line in my T-SQL code that contains a CREATE but does not include a following DBO. (not case-sensitve) to qualify the object being created. I am able to query all occurrences where CREATE and DBO exist, but have not had much luck trying to exclude where DBO did not follow the CREATE somewhere on the line.

For example, this below code finds all CREATE followed by a DBO on the line:

<CREATE(([^:a]+[:a]+)^1|([^:a]+[:a]+)^2|([^:a]+[:a]+)^3)[^:a]+DBO>

I just do not have the Regex mettle to find where a DBO does not trail the CREATE.

Any help would be greatly appreciated, as I am a little stuck on this one.

Thank you,
Tom

Post #1395826

Sean Lange

Posted Wednesday, December 12, 2012 11:58 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 8:46 AM
Points: 8,547, Visits: 8,204

like '%create%dbo%'

Not really sure what you are looking for. Also if you only the dbo schema why does it matter much if the object is not fully qualified?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1395831

tskelley

Posted Wednesday, December 12, 2012 12:10 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 6:34 AM
Points: 33, Visits: 758

Hello and thanks for the quick reply. I am trying to use the Regular Expressions feature in Find and Replace of the SSMS UI to search my text file that contains our T-SQL code.

Post #1395834

GSquared

Posted Wednesday, December 12, 2012 12:23 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

I don't think that's a regex issue. Wouldn't you just use a find with a "and not" in it? Find anything with CREATE, and not with the regex you already wrote?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1395839

tskelley

Posted Wednesday, December 12, 2012 3:52 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 6:34 AM
Points: 33, Visits: 758

I am using the Find and Replace dialog from within SSMS. I have a large text file (> 100K lines) that includes a delta of all our change scripts.

Post #1395910

Sean Lange

Posted Thursday, December 13, 2012 7:43 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 8:46 AM
Points: 8,547, Visits: 8,204

I still say that if you are only looking for dbo that it seems unnecessary. If you have only one schema everything will be created there anyway. Unless you are just trying to figure out how to make the regex work and you can tweak it slightly to check for each schema. I have never had great success with the regex tool in the search dialog. Maybe it is my inability to create complex regex. Wink

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1396195

« Prev Topic | Next Topic »

Permissions