Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .