regex101: Python Match Workspace

Pro

^start of line

Group 1(\w+)

\w+a Unicode word character, repeated at least once

Group 2(-odbc)?

?repeats the group contents below at most once:

-odbcthe literal text -odbc (case sensitive)

://the literal text ://

Group 3([\w-][\w.-]*)

Character Class[\w-]

\wa Unicode word character

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Character Class[\w.-]*

*matches any number of characters from the set below:

\wa Unicode word character

.the literal . (46₁₀ / 56₈ / 2E₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Non-Capturing Group(?::([a-zA-Z0-9]*))?

?repeats the group contents below at most once:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Group 4([a-zA-Z0-9]*)

Character Class[a-zA-Z0-9]*

*matches any number of characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Non-Capturing Group(?:/(\w[\w.-]*)\?([\w\\.#-]*)'&'([\w\\!.#-]*))?

?repeats the group contents below at most once:

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

Group 5(\w[\w.-]*)

\wa Unicode word character

Character Class[\w.-]*

*matches any number of characters from the set below:

\wa Unicode word character

.the literal . (46₁₀ / 56₈ / 2E₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

\?the literal ? (63₁₀ / 77₈ / 3F₁₆)

Group 6([\w\\.#-]*)

Character Class[\w\\.#-]*

*matches any number of characters from the set below:

\wa Unicode word character

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

.the literal . (46₁₀ / 56₈ / 2E₁₆)

#the literal # (35₁₀ / 43₈ / 23₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

'&'the literal text '&'

Group 7([\w\\!.#-]*)

Character Class[\w\\!.#-]*

*matches any number of characters from the set below:

\wa Unicode word character

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

!the literal ! (33₁₀ / 41₈ / 21₁₆)

.the literal . (46₁₀ / 56₈ / 2E₁₆)

#the literal # (35₁₀ / 43₈ / 23₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

$end of line

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

25 tokens

Regular Expression

^(\w+)(-odbc)?://([\w-][\w.-]*)(?::([a-zA-Z0-9]*))?(?:/(\w[\w.-]*)\?([\w\\.#-]*)'&'([\w\\!.#-]*))?$

New

mssql-odbc://sct-mssql-db.c6p0dl1fqnlk.us-east-1.rds.amazonaws.com:1433/sct_mssql_db?mssql_user'&'schemaconversion

Extraction

mssql-odbc://sct-mssql-db.c6p0dl1fqnlk.us-east-1.rds.amazonaws.com:1433/sct_mssql_db?mssql_user'&'schemaconversion