Regular Expressions 101

Non-Capturing Group(?:SERVICE_NAME|SID)

1st AlternativeSERVICE_NAME

SERVICE_NAMEthe literal text SERVICE_NAME (case sensitive)

2nd AlternativeSID

SIDthe literal text SID (case sensitive)

\s?optionally matches a Unicode whitespace character

=the literal = (61₁₀ / 75₈ / 3D₁₆)

\s?optionally matches a Unicode whitespace character

Group 1(.+?)

.+?any Unicode character (except for line terminators), repeated at least once

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

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

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?:SERVICE_NAME|SID)\s?=\s?(.+?)\)

New

SERVICE_NAME=db1)
SID=db1)