regex101: Java Substitution Workspace

^start of line

Non-Capturing Group(?:(?:(jdbc)\:{1})?(?:(\w+):/{2})?(?:([^@\/?!\"':#\s]+(?::\w+)?)@)?)?

?repeats the group contents below at most once:

Non-Capturing Group(?:(jdbc)\:{1})?

?repeats the group contents below at most once:

Group 1(jdbc)

jdbcthe literal text jdbc (case sensitive)

\:{1}the literal : (58₁₀ / 72₈ / 3A₁₆) , repeated exactly 1 time

Non-Capturing Group(?:(\w+):/{2})?

?repeats the group contents below at most once:

Group 2(\w+)

\w+any word character, repeated at least once

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

/{2}the literal / (47₁₀ / 57₈ / 2F₁₆) , repeated exactly 2 times

Non-Capturing Group(?:([^@\/?!\"':#\s]+(?::\w+)?)@)?

?repeats the group contents below at most once:

Group 3([^@\/?!\"':#\s]+(?::\w+)?)

Negated Character Class[^@\/?!\"':#\s]+

+matches at least one character outside the set below:

@the literal @ (64₁₀ / 100₈ / 40₁₆)

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

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

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

\"the literal " (34₁₀ / 42₈ / 22₁₆)

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

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

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

\sany whitespace character

Non-Capturing Group(?::\w+)?

?repeats the group contents below at most once:

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

\w+any word character, repeated at least once

@the literal @ (64₁₀ / 100₈ / 40₁₆)

Non-Capturing Group(?:([^@\/?!\"':#\s]+(?::\d+)?)(?=(?:$)|(?:/)))?

?repeats the group contents below at most once:

Group 4([^@\/?!\"':#\s]+(?::\d+)?)

Negated Character Class[^@\/?!\"':#\s]+

+matches at least one character outside the set below:

@the literal @ (64₁₀ / 100₈ / 40₁₆)

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

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

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

\"the literal " (34₁₀ / 42₈ / 22₁₆)

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

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

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

\sany whitespace character

Non-Capturing Group(?::\d+)?

?repeats the group contents below at most once:

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

\d+a digit, repeated at least once

Positive Lookahead(?=(?:$)|(?:/))

1st Alternative(?:$)

Non-Capturing Group(?:$)

$end of line

2nd Alternative(?:/)

Non-Capturing Group(?:/)

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

Non-Capturing Group(?:/([^@?!\"':#\s]*)(?=(?:$)|(?:\?)))?

?repeats the group contents below at most once:

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

Group 5([^@?!\"':#\s]*)

Negated Character Class[^@?!\"':#\s]*

*matches any number of characters outside the set below:

@the literal @ (64₁₀ / 100₈ / 40₁₆)

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

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

\"the literal " (34₁₀ / 42₈ / 22₁₆)

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

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

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

\sany whitespace character

Positive Lookahead(?=(?:$)|(?:\?))

1st Alternative(?:$)

Non-Capturing Group(?:$)

$end of line

2nd Alternative(?:\?)

Non-Capturing Group(?:\?)

Non-Capturing Group(?:[?]([^#?!\s]+))?

\S*any non-whitespace character, repeated any number of times

$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

Search reference

Regular Expression

^(?:(?:(jdbc)\:{1})?(?:(\w+):/{2})?(?:([^@\/?!\"':#\s]+(?::\w+)?)@)?)?(?:([^@\/?!\"':#\s]+(?::\d+)?)(?=(?:$)|(?:/)))?(?:/([^@?!\"':#\s]*)(?=(?:$)|(?:\?)))?(?:[?]([^#?!\s]+))?\S*$

New

postgresql://
postgresql://localhost
postgresql://localhost:5432
postgresql://localhost/mydb
postgresql://user@localhost
postgresql://user:secret@localhost
postgresql://user:secret@localhost:1533
postgresql://user:secret@localhost:1533/
postgresql://user:secret@localhost:1533/db?
postgresql://user::se:::cret@localhost::port
postgresql://user::secret@local::host::po::::rt/dd::b:::b
postgresql://other@localhost/otherdb?connect_timeout=10&application_name=myapp
postgresql://localhost/mydb?user=other&password=secret
jdbc:postgresql://localhost
jdbc:postgresql://other@localhost/otherdb?connect_timeout=10&application_name=myapp
jdbc:postgresql://other@localhost:5432/otherdb?connect_timeout=10&application_name=myapp
jdbc:postgresql://other:pass@localhost:5432/otherdb?connect_timeout=10&application_name=myapp
jdbc:postgresql://other:pass@localhost:5432/other/db?connect_timeout=10&application_name=myapp
jdbc:postgresql://other:pass@localhost:5432/other/db??connect_timeout=10&application_name=myapp
jdbc:postgresql://other::pass@localhost::5432/oth:erdb?connect_timeout=10&application_name=myapp
""''":::abc;
postgresql://127.0.0.1::5432
127.0.0.1::5432
localhost
user@localhost
user@localhost:1533
user@localhost:1533/db
user@localhost:1533/db?
user:secret@localhost
user:secret@localhost/db
user:secret@localhost/db?
user:secret@local:host/otherdb
user:secret@local:1533/othe1//db
user:secret@localhost/otherdb?connect_timeout=10&application_name=myapp
user:secret@localhost/other/db?connect_timeout=10&application_name=myapp
user:secret@localhost/other/db??connect_timeout=10&application_name=myapp
us""er:se::cret@loca''lhost
user:secret@local:1533/otherdb
jdbc:postgresql://user:secret@localhost:1533/otherdb
jdbc:postgresql://user:secret@@localhost:1533/otherdb
jdbc:postgresql://user:secret@localhost:1533/otherdb?
jdbc:postgresql://:secret@localhost:1533/otherdb?
jdbc:postgresql://user:secret@:1533/otherdb?
jdbc:postgresql://user:secret@localhost:1533/@otherdb?
jdbc:postgresql://user:secret@localhost/otherdb?connect_timeout=10&application_name=myapp
jdbc:postgresql://user:secret@localhost:1533/otherdb?connect_timeout=10&application_name=myapp
jd''bc:post""gresql://us..er:sec,,ret@localh++ost/ot+-herdb?connect_timeout=10&application_name=myapp

Substitution

$1 \n$2 \n$3 \n$4 \n$5 \n---\n