Regular Expressions 101

exec the literal text exec (case sensitive)

\w+any word character, repeated at least once

the literal (32₁₀ / 40₈ / 20₁₆)

Non-Capturing Group(?:.*?'(?<quotedWord>\w+)')+

+repeats the group contents below at least once:

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

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Group quotedWord(?<quotedWord>\w+)

\w+any word character, repeated at least once

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

exec \w+ (?:.*?'(?<quotedWord>\w+)')+

New

exec GetNextSequence 'abc', @brokerId out, 'fds'
insert into [ttt](id, code, description, startDate, endDate)
values (@bid, @code, @code, getdate(), '099999')
....

Regular Expression

Extraction