Please enable JavaScript to use this web application.
Regular
Expressions
101
Social
Social
Join the Discord community!
Follow me on twitter!
Send me an email
Donate
Donate
Donate through Paypal
Become a Github Sponsor
Info
Info
Find out what's new!
RegEx101 Wiki
Report bugs or make suggestions
What's new?
Loading content...
Close
Regex Editor
Regex Editor
Community Patterns
Community Patterns
Account
Account
Regex Quiz
Regex Quiz
Settings
Settings
Live Help
Live Help
Get help on Discord
Get help on IRC
Order By
Most Recent
Highest Score
Lowest Score
Most upvotes
Most downvotes
Filter by Flavor
PCRE2 (PHP >=7.3)
PCRE (PHP <7.3)
ECMAScript (JavaScript)
Python
Golang
Java 8
.NET (C#)
Rust
Sponsors
Community Patterns
Search among 9,420 community submitted regex patterns...
11
42 upvotes, 31 downvotes (score 46.1%) (You must be signed in to vote)
Date(Including Leap Year) YYYY-MM-DD hh:mm:ss
PCRE (PHP <7.3)
Validates DateTime of format YYYY-MM-DD hh:mm:ss including Leap Year
Submitted by
Madhan
-
10 years ago
2014-03-14 16:49
-2
4 upvotes, 6 downvotes (score 16.8%) (You must be signed in to vote)
Match v4 IP address
PCRE (PHP <7.3)
no description available
Submitted by
Budiony Damyanov
-
10 years ago
2014-03-14 13:05
-3
1 upvotes, 4 downvotes (score 3.6%) (You must be signed in to vote)
DateTime YYYY-MM-DD hh:mm:ss
PCRE (PHP <7.3)
no description available
Submitted by
Madhan
-
10 years ago
2014-03-14 12:29
4
5 upvotes, 1 downvotes (score 43.6%) (You must be signed in to vote)
Hungarian ANDOK system id
PCRE (PHP <7.3)
no description available
Submitted by
Tana
-
10 years ago
2014-03-12 15:35
6
9 upvotes, 3 downvotes (score 46.8%) (You must be signed in to vote)
ID003 device info
PCRE (PHP <7.3)
no description available
Submitted by
sasjaq
-
10 years ago
2014-03-12 09:38
-2
1 upvotes, 3 downvotes (score 4.6%) (You must be signed in to vote)
[A-Z]+[a-z]{1,2}[0-9]*
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
10 years ago
2014-03-11 13:57
-2
1 upvotes, 3 downvotes (score 4.6%) (You must be signed in to vote)
A masz!
PCRE (PHP <7.3)
no description available
Submitted by
Ja
-
10 years ago
2014-03-03 15:09
-2
1 upvotes, 3 downvotes (score 4.6%) (You must be signed in to vote)
failed attempt
PCRE (PHP <7.3)
no description available
Submitted by
DynV
-
10 years ago
2014-03-03 04:40
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Test Listing Parser
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
10 years ago
2014-03-01 18:00
-2
1 upvotes, 3 downvotes (score 4.6%) (You must be signed in to vote)
Ukazka
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
10 years ago
2014-02-28 13:01
-2
10 upvotes, 12 downvotes (score 26.9%) (You must be signed in to vote)
Remove empty HTML tags
PCRE (PHP <7.3)
Removes empty HTML tags. Was needed for old input clean-up and to keep a HTML parses from crashing. Looking for improvement on bottom test.
Submitted by
R. Sartorius
-
10 years ago
2014-02-26 13:21
3
3 upvotes, 0 downvotes (score 43.8%) (You must be signed in to vote)
Task 2, part 1
PCRE (PHP <7.3)
Finds all source numbers in square brackets
Submitted by
Kovalev Evgeny
-
10 years ago
2014-02-25 06:13
4
7 upvotes, 3 downvotes (score 39.7%) (You must be signed in to vote)
Task 1
PCRE (PHP <7.3)
Finds a happy smile, except sad one
Submitted by
Kovalev Evgeny
-
10 years ago
2014-02-25 05:48
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Task 1
PCRE (PHP <7.3)
no description available
Submitted by
Kovalev Evgeny
-
10 years ago
2014-02-25 05:47
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
srt
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
10 years ago
2014-02-24 17:49
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
example regex
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
10 years ago
2014-02-24 07:51
1
2 upvotes, 1 downvotes (score 20.8%) (You must be signed in to vote)
parse SQL statements and get values
PCRE (PHP <7.3)
but it does not work. How do I make it work? It will be used in C#
Submitted by
anonymous
-
10 years ago
2014-02-22 04:18
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
match up to -
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
10 years ago
2014-02-19 17:08
0
5 upvotes, 5 downvotes (score 23.7%) (You must be signed in to vote)
Improved regex101 ID grabber (fixed)
PCRE (PHP <7.3)
no description available
Submitted by
Oleksandr Sochka
-
10 years ago
2014-02-17 22:09
0
1 upvotes, 1 downvotes (score 9.5%) (You must be signed in to vote)
IMAP Status Response with MESSAGE and UNSEEN count
PCRE (PHP <7.3)
Matches the folder name (as IMAP ATOM, Quoted String or Literal String) and folder message total and unseen count.
Submitted by
Mike Johnson
-
10 years ago
2014-02-17 17:29
1
...
463
464
465
466
467
468
469
...
471
parse SQL statements and get values
1
2 upvotes, 1 downvotes (score 20.8%) (You must be signed in to vote)
Regular Expression
PCRE (PHP <7.3)
/
(?<=
\b
(
create
|
alter
|
drop
)
\s
+(
procedure
|
proc
|
table
|
trigger
|
view
|
function
)
\b\s
\[
dbo
\]
.
)
\[
.
*
?
\]
/
im
Open regex in editor
Description
Loading markdown...
Submitted by
anonymous
-
10 years ago
2014-02-22 04:18