Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
(theColumnName)[\s\S]*?[\d]+
/
g
Input 1
New
Line 62: DECLARE @pStrtheColumnName VARCHAR(10) Line 198: theColumnName VARCHAR(10), Line 282: INSERT INTO #Temp(theColumnName Line 297: SELECT P.SomeCol, P.theColumnName, P.OtherColumn, P.AnotherCol, Line 385: SELECT SomeCol, theColumnName, AnotherCol, ThirdCol, Line 400: ORDER BY Col1, Col2, theColumnName Line 404: FETCH NEXT FROM curCMS INTO @pStrCode, @pStrtheColumnName, @pSomeDate, Line 436: SET @pStrProcessLine = @pStrProcessLine + ISNULL(SUBSTRING(@pStrtheColumnName,1,10), '') + @pStrDelimiter Line 555: FETCH NEXT FROM myCursor INTO @pStrCode, @pStrtheColumnName, @pSomeDate, Line 597: ORDER BY E.SomeDate, E.AnotherDate, E.theColumnName Line 654: + 'ORDER BY AdmissionDate, DischargeDate, theColumnName' + @Cr
Substitution
Line 62: DECLARE @pStrtheColumnName VARCHAR(10) Line 198: theColumnName VARCHAR(10), Line 282: INSERT INTO #Temp(theColumnName Line 297: SELECT P.SomeCol, P.theColumnName, P.OtherColumn, P.AnotherCol, Line 385: SELECT SomeCol, theColumnName, AnotherCol, ThirdCol, Line 400: ORDER BY Col1, Col2, theColumnName Line 404: FETCH NEXT FROM curCMS INTO @pStrCode, @pStrtheColumnName, @pSomeDate, Line 436: SET @pStrProcessLine = @pStrProcessLine + ISNULL(SUBSTRING(@pStrtheColumnName,1,10), '') + @pStrDelimiter Line 555: FETCH NEXT FROM myCursor INTO @pStrCode, @pStrtheColumnName, @pSomeDate, Line 597: ORDER BY E.SomeDate, E.AnotherDate, E.theColumnName Line 654: + 'ORDER BY AdmissionDate, DischargeDate, theColumnName' + @Cr