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 17,160 community submitted regex patterns...
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Google Category Extraction
PCRE (PHP <7.3)
Extract first term in url path for google category extraction
Submitted by
SCFarmer
-
7 years ago
2016-06-28 13:37
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
dd
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-28 07:52
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
find latitude longitude
PCRE (PHP <7.3)
find & get long lat in a string
Submitted by
Michael CAILLET http://mica.bike
-
7 years ago
2016-06-28 02:12
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Modernest of Emails
PCRE (PHP <7.3)
New gTLDs (2-14 chars) Allows sentence endings after email Accepts every char (except space) = Full Email Support ...
Submitted by
timmyRS
-
7 years ago
2016-06-28 00:20
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
SIEM Extended Attribute Regex
PCRE (PHP <7.3)
no description available
Submitted by
Stephen Kim
-
7 years ago
2016-06-27 20:45
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
dd
ECMAScript (JavaScript)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-27 19:47
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Lynda Anchors
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-27 19:24
2
2 upvotes, 0 downvotes (score 34.2%) (You must be signed in to vote)
IBAN
ECMAScript (JavaScript)
The complete regex for IBAN numbers
Submitted by
anonymous
-
7 years ago
2016-06-27 18:57
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
International Phone Codes
ECMAScript (JavaScript)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-27 16:30
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Email
PCRE (PHP <7.3)
Refunds email validation
Submitted by
Greg Kedge
-
7 years ago
2016-06-27 13:50
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Your BANK a/c xxxx 4114 will be debited for Rs 97856.5 towards HDFCBan
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-27 13:30
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
No Double space and special character, no leading space ISO-8859-1
PCRE (PHP <7.3)
Matches everything exept a String with one of the following: Leading or ending space multiple spaces double special character
Submitted by
Hunziger
-
7 years ago
2016-06-27 08:25
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Full URL
PCRE (PHP <7.3)
IPs Domains Ports Directories Files ...
Submitted by
timmyRS
-
7 years ago
2016-06-27 07:49
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
xref phone number
Python
no description available
Submitted by
anonymous
-
7 years ago
2016-06-27 07:24
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Save
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-27 05:23
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
re
Python
no description available
Submitted by
anonymous
-
7 years ago
2016-06-26 18:53
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
match directory paths with names
ECMAScript (JavaScript)
crazy rhumbl regex for build
Submitted by
luwenh
-
7 years ago
2016-06-24 22:47
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
HTML tag search
Python
finds the common html tags
Submitted by
Henri Mulder
-
7 years ago
2016-06-24 20:46
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
ADCE - Validación
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-24 13:26
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
ADCE Descomposición
PCRE (PHP <7.3)
no description available
Submitted by
anonymous
-
7 years ago
2016-06-24 13:24
1
...
629
630
631
632
633
634
635
...
858
Extracts table names from SELECT query
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Regular Expression
PCRE (PHP <7.3)
/
(?<=
FROM
|
JOIN
|
OJ
)
[
\s
\(
]
+
(
(
(
(?!
SELECT
\b
)
`
?
[
\w
_
]
+
`
?
)
(
\s
*
\)
?
,
\s
*
)*
)+
)
/
gi
Open regex in editor
Description
Loading markdown...
Submitted by
Mykhaylo Khodorev (mykhaylo.khodorev@gmail.com)
-
7 years ago
2016-05-29 22:34