Regular Expressions 101

convertthe literal text convert (case sensitive)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Negated Character Class[^,]+

+matches at least one character outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Negative Lookahead(?!convert)

convertthe literal text convert (case sensitive)

Group 1([^,]+)

Negated Character Class[^,]+

+matches at least one character outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Global pattern flags

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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

convert\([^,]+,(?!convert)([^,]+)

New

convert(nvarchar(10),convert(datetime,VARIABLE02 , 121), 103)
convert(datetime,VARIABLE02 , 121) convert(datetime,VARIABLE02 , 121)

convert(nvarchar(10),convert(datetime,VARIABLE02 , 121), 103)
convert(datetime,VARIABLE02 , 121) convert(datetime,VARIABLE02 , 121)