Regular Expressions 101

Pro

1st AlternativeData Source\s*=\s*

Data Sourcethe literal text Data Source (case sensitive)

\s*a Unicode whitespace character, repeated any number of times

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

\s*a Unicode whitespace character, repeated any number of times

2nd AlternativeServer=tcp:(.*?),

Server=tcp:the literal text Server=tcp: (case sensitive)

Group 1(.*?)

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

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

3rd Alternative;

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

Data Source\s*=\s*|Server=tcp:(.*?),|;

New

Server=tcp:SYD-SQLPROD01,1433;database=ARNOTTS_OSA_OOS; Integrated Security = SSPI
Data Source=SYD-SQLPROD01\blueprint,6143;Initial Catalog=MB_CTP_Live;Integrated Security=True

Substitution

Server=tcp:SYD-SQLPROD01,1433;database=ARNOTTS_OSA_OOS; Integrated Security = SSPI
Data Source=SYD-SQLPROD01\blueprint,6143;Initial Catalog=MB_CTP_Live;Integrated Security=True