Regular Expressions 101

1st Alternative(--.*)

Group 1(--.*)

--the literal text --

.*any character (except for line terminators), repeated any number of times

2nd Alternative(((\/\*)+?[\w\W]+?(\*\/)+))

Group 2(((\/\*)+?[\w\W]+?(\*\/)+))

Group 3((\/\*)+?[\w\W]+?(\*\/)+)

Group 4(\/\*)+?

+?repeats the group contents below at least once:

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

Character Class[\w\W]+?

+?matches at least one character from the set below:

\wany word character

\Wany non-word character

Group 5(\*\/)+

+repeats the group contents below at least once:

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(--.*)|(((\/\*)+?[\w\W]+?(\*\/)+))

New

--GO
--SET ANSI_NULLS ON
--GO
--SET QUOTED_IDENTIFIER ON
--GO

/*
    DECLARE @Gas SMALLDATETIME = '1/1/2016',
            @System              VARCHAR(Max) = '30',--'12,76,466,465,30,226',
            /*following param is to help decide Transportation or Storage */
            @Contract         INT = 0,--Transport or (1 = storage). 
            /*following param is to help decide dth or %*/
            -- Contract Period 0 = 5 Years, 1 = 10 years,..., 4=25 years
            
*/

Regular Expression

Substitution