Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm going crazy on a weird issue, I've been trying to find this text:

CREATE Proc [dbo].[procName] (@EMI_ID numeric(8), @ESYNTH_ID numeric(8), @FLD_ID numeric(8), @SYNTH_ID numeric(8)) As

And I use this regex:

CREATE Proc \[dbo\]\.\[(.+)\] \(@EMI_ID numeric\(8\), @ESYNTH_ID numeric\(8\), @FLD_ID numeric\(8\), @SYNTH_ID numeric\(8\)\) As

In the "find"
However this won't work, BUT if I try to match with just this regex (same as above but without the last stored proc parameter):

CREATE Proc \[dbo\]\.\[(.+)\] \(@EMI_ID numeric\(8\), @ESYNTH_ID numeric\(8\), @FLD_ID numeric\(8\),

It works without problem.

I have also tried to use TextFX's Find and Replace to no avail.
Please help, madness consumes me!

Thanks ;)

share|improve this question
Related:… – Oliver Salzburg Apr 2 '12 at 16:10
up vote 3 down vote accepted

yup your regex is correct.

but notepad++ seems to be in my tests limited to 103 char, regex string.

CREATE Proc \[dbo]\.\[(.+)\] \(@EMI_ID numeric\(8\), @ESYNTH_ID numeric\(8\), @FLD_ID numeric\(8\), @S

tested and found multi in text file i created.

hope this helps.

share|improve this answer

Although not the nicest regex, your first regex should match the target string. This is a fault with Notepad++.

I find A Programmer's Notepad to be a better text editor, and in fact your regex works in this program,

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.