Regular Expressions 101

Order By

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

Community Patterns

13

PHP variable name

PCRE (PHP <7.3)
Valid PHP variable name as defined in the manual at http://php.net/manual/en/language.variables.basics.php
Submitted by Erin Millard - 12 years ago
52

Disorted Email Addresses

PCRE (PHP <7.3)
Matches distorted email addresses and converts them back to real ones.
Submitted by dislick - 12 years ago
40

URL regexp

PCRE (PHP <7.3)
A quite neat regular expression for URLs, e-mails..., I found on Matthew O'Riordan's blog.
Submitted by Matthew O'Riordan - 12 years ago
1...900901902

Community Library Entry

0

Regular Expression
PCRE2 (PHP >=7.3)

/
name="\w+".*connectionString=.*((data source=([\w0-9_\.-]+);|initial catalog=([\w0-9_\.-]+);).*){2}
/
gm
Open regex in editor

Description

given a connection string to MSSQL server, we want to extract the URL and the name of the database. these are the "data source" and "initial catalog" fields respectively. The regex does not assume an order between those fieldss

Submitted by Noam - 2 years ago (Last modified 2 years ago)