Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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: superuser.com/questions/339658/… –  Oliver Salzburg Apr 2 '12 at 16:10
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

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.