Please enable JavaScript to use this web application.
Regular
Expressions
101
Social
Donate
Info
Regex Editor
Community Patterns
Account
Regex Quiz
Settings
Order By
Most Recent
Most upvotes
Most downvotes
Highest Score
Lowest Score
Filter by Flavor
PCRE2 (PHP >=7.3)
PCRE (PHP <7.3)
ECMAScript (JavaScript)
Python
Golang
Java 8
.NET 7.0 (C#)
Rust
Sponsors
There are currently no sponsors.
Become a sponsor today!
Community Patterns
Search among 18,000 community submitted regex patterns...
0
Wie arbeiten RegEx?
PCRE2 (PHP >=7.3)
Beispiel zur Lektion "Wie arbeiten RegEx?".
Submitted by
Ruben Winkler - Der ultimative Regular Expression Komplettkurs
-
3 years ago
0
匹配敏感词
Python
用"第一|质量|最"这些敏感词来寻找并匹配字符串
Submitted by
anonymous
-
3 years ago
0
IBAN Search
PCRE2 (PHP >=7.3)
with white space and capitals
Submitted by
anonymous
-
3 years ago
0
Date YYYY-MM-DD | YYYY/MM/DD | YYYY.MM.DD (ex. 2021-12-09) (leading zeros for month and day)
Python
For Dates formatted YYYY-MM-DD separated by Dot (.) Dash(-) or Slash(/) like (2021-04-08) with Zeros for single digit Month and Day.
Submitted by
QuickRegEx
-
3 years ago
0
Date YYYY-M-D | YYYY/M/D | YYYY.M.D (ex. 2021-9-2) (without leading zeros for month and day)
Python
For Dates formatted YYYY-M-D separated by Dot (.) Dash(-) or Slash(/) like (2021-9-2) without leading Zeros for single digit Month and Day.
Submitted by
QuickRegEx
-
3 years ago
0
Date MM-DD-YYYY | MM/DD/YYYY | MM.DD.YYYY (ex. 09-02-2021) (leading zeros for month and day)
Python
For Dates formatted MM-DD-YYYY separated by Dot (.) Dash(-) or Slash(/) like (09-02-2021) with leading Zeros for single digit Month and Day.
Submitted by
QuickRegEx
-
3 years ago
0
Date M-D-YYYY | M/D/YYYY | M.D.YYYY (ex. 9-2-2021) (without leading zeros for month and day)
Python
For Dates formatted M-D-YYYY separated by Dot (.) Dash(-) or Slash(/) like (9-2-2021) without leading Zeros for single digit Month and Day.
Submitted by
QuickRegEx
-
3 years ago
0
Date DD-MM-YYYY | DD/MM/YYYY | DD.MM.YYYY (ex. 28-02-2021) (leading zeros for month and day)
Python
For Dates formatted DD-MM-YYYY separated by Dot (.) Dash(-) or Slash(/) like (28–02-2021) with leading Zeros for single digit Month and Day.
Submitted by
QuickRegEx
-
3 years ago
0
Date D-M-YYYY | D/M/YYYY | D.M.YYYY (ex. 28-02-2021) (without leading zeros for month and day)
Python
For Dates formatted D-M-YYYY separated by Dot (.) Dash(-) or Slash(/) like (28-2-2021) without leading Zeros for single digit Month and Day.
Submitted by
QuickRegEx
-
3 years ago
0
URL utm_source (extract UTM Source from a URL String)
Python
Extract utm_source from a URL String
Submitted by
QuickRegEx
-
3 years ago
0
URL utm_medium (extract UTM Medium from a URL String)
Python
Extract utm_medium from a URL String
Submitted by
QuickRegEx
-
3 years ago
0
URL utm_campaign (extract UTM Campaign from a URL String)
Python
Extract utm_campaign from a URL String
Submitted by
QuickRegEx
-
3 years ago
0
URL utm_content (extract UTM Content from a URL String)
Python
Extract utm_content from a URL String
Submitted by
QuickRegEx
-
3 years ago
0
URL utm_term (extract UTM Term from a URL String)
Python
Extract utm_term from a URL String
Submitted by
QuickRegEx
-
3 years ago
0
Email Parse Name with Colon (Name: )
Python
For getting the value after “Name: “ in a block of text
Submitted by
QuickRegEx
-
3 years ago
0
Email Parse Email with Colon (Email: )
Python
For getting the value after “Email: “ in a block of text
Submitted by
QuickRegEx
-
3 years ago
0
Email Parse Phone with Colon (Phone: )
Python
For getting the value after “Phone: “ in a block of text
Submitted by
QuickRegEx
-
3 years ago
0
Email Parse City with Colon (City: )
Python
For getting the value after “City: “ in a block of text
Submitted by
QuickRegEx
-
3 years ago
0
Email Parse State with Colon (State: )
Python
For getting the value after “State: “ in a block of text
Submitted by
QuickRegEx
-
3 years ago
0
Email Parse Zip with Colon (Zip: )
Python
For getting the value after “Zip: “ in a block of text
Submitted by
QuickRegEx
-
3 years ago
1
...
754
755
756
757
758
...
900
Community Library Entry
0
Regular Expression
ECMAScript (JavaScript)
/
#
Time:
\s
(?<timestamp>
.
*
)
\n
#
.
*
Id:
\s
(?<id>
.
*
)
\n
#
\s
Query_time:
\s
(?<duration>
[
\d
.
]
*
)
\s.
*
time:
\s
(?<lock_time>
[
\d
.
]
*
)
\s.
*
_sent:
\s
(?<returned>
\d
*
)
\s.
*
_examined:
\s
(?<searched>
\d
*
)
\n
(?<sql>
[
\s\S
]
*
)
/
gm
Open regex in editor
Description
Parse the CloudWatch mysql slowlog into coherent fields.
Submitted by
Frank Baxter
-
3 years ago