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 5,600 community submitted regex patterns...
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
index_re
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-29 05:55
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
lineup.re
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-29 10:14
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
hours - 12 hours format
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-29 13:58
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
index_capital letter line up
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-29 14:48
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
cf categories find
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-29 15:00
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
US zip code
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-29 23:07
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Log error code
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-30 14:14
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
adding international code
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-30 14:32
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
3 voyels word
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-30 14:44
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
substitute python comment
Python
no description available
Submitted by
anonymous
-
3 years ago
2020-05-30 14:52
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Detect queries and whitespace before each of them
ECMAScript (JavaScript)
no description available
Submitted by
anonymous
-
3 years ago
2020-05-30 16:31
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Detect queries and whitespace after each of them
ECMAScript (JavaScript)
no description available
Submitted by
anonymous
-
3 years ago
2020-05-30 16:39
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Airtel Unlimited Plan
Python
Airtel Unlimited Plan
Submitted by
starkm42
-
a year ago
2022-04-04 05:15
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
usa number
ECMAScript (JavaScript)
using this regular expression you can implement usa number validation.
Submitted by
ebuy
-
a year ago
2022-04-05 10:19
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Sign-In with Ethereum
ECMAScript (JavaScript)
This is the complete Sign-In with Ethereum RegExp implementation
Submitted by
anonymous
-
a year ago
2022-04-05 14:16
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
extract id in filename psd from path ftp
ECMAScript (JavaScript)
extract id in filename psd from path ftp
Submitted by
loochanin
-
a year ago
2022-04-05 16:49
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Match Time HH:MM:SS
ECMAScript (JavaScript)
It checks for time in 24hr format with colon separator
Submitted by
OMKAR AGRAWAL
-
a year ago
2022-04-06 08:37
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
CSS base64 data stream
ECMAScript (JavaScript)
Match Base64 data stream inside CSS file (WOFF/WOFF2)
Submitted by
Anoir Ben Tanfous
-
a year ago
2022-04-07 08:34
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
分组
ECMAScript (JavaScript)
显示分组
Submitted by
Jason
-
a year ago
2022-04-08 04:24
0
0 upvotes, 0 downvotes (score 0%) (You must be signed in to vote)
Match Internal Links
ECMAScript (JavaScript)
Detect internal links in page
Submitted by
anonymous
-
a year ago
2022-04-10 11:33
(Last modified a year ago)
2022-04-10 12:11
1
...
246
247
248
249
250
251
252
...
280
Extract Sql Columns from the given query
1
1 upvotes, 0 downvotes (score 20.7%) (You must be signed in to vote)
Regular Expression
ECMAScript (JavaScript)
/
(?:
\s
*
(?=
\w
+
\.
|
.
*
as
\s
+
|
distinct
\s
+
|)
(
\*
|
\w
+
)
(?=
\s
*
(?=
,
|
from
)
)
)
/
ig
Open regex in editor
Description
Loading markdown...
Submitted by
anonymous
-
7 years ago
2016-10-17 06:54