Regular Expressions 101

Save & Share

  • Regex Version: ver. 1
  • Update Regex
    ctrl+⇧+s
  • Save new Regex
    ctrl+s
  • Add to Community Library

Flavor

  • PCRE2 (PHP >=7.3)
  • PCRE (PHP <7.3)
  • ECMAScript (JavaScript)
  • Python
  • Golang
  • Java 8
  • .NET 7.0 (C#)
  • Rust
  • Regex Flavor Guide

Function

  • Match
  • Substitution
  • List
  • Unit Tests

Tools

Sponsors
There are currently no sponsors. Become a sponsor today!
An explanation of your regex will be automatically generated as you type.
Detailed match information will be displayed here automatically.
  • All Tokens
  • Common Tokens
  • General Tokens
  • Anchors
  • Meta Sequences
  • Quantifiers
  • Group Constructs
  • Character Classes
  • Flags/Modifiers
  • Substitution
  • A single character of: a, b or c
    [abc]
  • A single character of: a, b, c or d
    [[ab][cd]]
  • A character except: a, b or c
    [^abc]
  • A character in the range: a-z
    [a-z]
  • A character not in the range: a-z
    [^a-z]
  • A character in the range: a-z or A-Z
    [a-zA-Z]
  • Character class intersection
    [\w&&[^\d]]
  • Any single character
    .
  • Alternate - match either a or b
    a|b
  • Any whitespace character
    \s
  • Any non-whitespace character
    \S
  • Any digit
    \d
  • Any non-digit
    \D
  • Any word character
    \w
  • Any non-word character
    \W
  • Non-capturing group
    (?:...)
  • Capturing group
    (...)
  • Zero or one of a
    a?
  • Zero or more of a
    a*
  • One or more of a
    a+
  • Exactly 3 of a
    a{3}
  • 3 or more of a
    a{3,}
  • Between 3 and 6 of a
    a{3,6}
  • Start of string
    ^
  • End of string
    $
  • A word boundary
    \b
  • Non-word boundary
    \B

Regular Expression
No Match

"
"
gm

Test String

Substitution

Processing...

Code Generator

Generated Code

re = /^(?:(?:(jdbc)\:{1})?(?:(\w+):\/{2})?(?:([^@\/?!\"':#\s]+(?::\w+)?)@)?)?(?:([^@\/?!\"':#\s]+(?::\d+)?)(?=(?:$)|(?:\/)))?(?:\/([^@?!\"':#\s]*)(?=(?:$)|(?:\?)))?(?:[?]([^#?!\s]+))?\S*$/m str = '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' subst = '$1 \\n$2 \\n$3 \\n$4 \\n$5 \\n---\\n' result = str.gsub(re, subst) # Print the result of the substitution puts result

Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Ruby, please visit: http://ruby-doc.org/core-2.2.0/Regexp.html