Regular Expressions 101

Order By

Sponsors
There are currently no sponsors. Become a sponsor today!

Community Patterns

-18

dd-mm-YYYY HH:mm:ss (year range 1000-2999)

PCRE (PHP <7.3)
Validate Gregorian calendar dates that contain 24-hour times. This will also correctly match the Feb 29 date when it falls on a valid leap year. Leap years occur every 4 years, with one exception: when a year is evenly divisible by 100 but not evenly divisible by 400, the year will not be a leap ye...
Submitted by Ka. - 11 years ago (Last modified a year ago)
-4

Date with this format YYYY-MM-DD and year start 20 or 21

PCRE (PHP <7.3)
Date with this format YYYY-MM-DD and year start 20 or 21 like 2014
Submitted by cisc0 - 11 years ago
-3

Date and Time

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 11 years ago
-3

Latitude/longitude tester

PCRE (PHP <7.3)
Tests the string if it does contain valid latitude and longitude parameters
Submitted by Doro - 11 years ago
-3

british postcode check

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 10 years ago
-3

British Postcode Check

PCRE (PHP <7.3)
no description available
Submitted by guest - 10 years ago
-3

regex help

PCRE (PHP <7.3)
help please. i need regex,
Submitted by James - 10 years ago
-3

mama

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 10 years ago
-3

Select a HTML table and all its innerHTML

PCRE (PHP <7.3)
no description available
Submitted by @ixzy24 - 10 years ago
-3

Match email addresses and get the mail provider as a group

PCRE (PHP <7.3)
no description available
Submitted by Ole - 9 years ago
-3

RegEX for account code starting with 000-

PCRE (PHP <7.3)
no description available
Submitted by Joe H - 9 years ago
-3

Telephone

PCRE (PHP <7.3)
Find Telephone
Submitted by Mr.Fail - 9 years ago
-3

FQDN Fully Qualified Domain Name

PCRE (PHP <7.3)
no description available
Submitted by Rafael Justo and Mauro Trajber - 9 years ago
-3

ipv4 - short version

PCRE (PHP <7.3)
no description available
Submitted by gromozeka - 9 years ago
-3

UpperCase words

PCRE (PHP <7.3)
no description available
Submitted by ivo - 9 years ago
-3

a

PCRE (PHP <7.3)
a
Submitted by a - 9 years ago
-3

Facebook url regex

PCRE (PHP <7.3)
no description available
Submitted by Devs Devaras - 9 years ago
-3

Replace abba with ABBA

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 9 years ago
-3

get table name from mapfile

PCRE (PHP <7.3)
gets a postgis tablename from a mapfile with the given layer name, may not work depending on your mapfile layout
Submitted by warnock - 9 years ago
-3

Clean empty tags from HTML tags incl. tags containing space(s)

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 9 years ago
123...481

Community Library Entry

1

Regular Expression
Java 8

"
(.*?)(?:\(#\d+\))?$
"
gm
Open regex in editor

Description

This regex expression is useful for extracting only the text string from a value in a column that may contain values from individual rows with repeat strings tagged with a suffix. For example - Row 1: "Sales (#1)", Row 2: "Sales Match (#2)". From the shared examples, this regex will extract the text "Sales" and "Sales Match."

Submitted by nilotpalc - a year ago