Regular Expressions 101

Order By

Sponsors

Community Patterns

0

Add "r" to middle of column name

PCRE (PHP <7.3)
Used this in the L2C data
Submitted by anonymous - 3 years ago
0

Coronadashboard vaccinatie buildID

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

viptela

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

get all digits in sequence

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

Detect helm charts directory

PCRE (PHP <7.3)
no description available
Submitted by ducthinh993@gmail.com - 3 years ago
0

Test

PCRE (PHP <7.3)
TEst
Submitted by Zac - 3 years ago
0

Get Hash Tags from tweet

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

elektro cnpj

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

elektro modalidade

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

elextro grupo

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

elektro total

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

European home adresse

PCRE (PHP <7.3)
Find european address (France, Italy, Suisse, Germany)
Submitted by Anthony Chaussin - 3 years ago
0

split_Path

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

split_amazon_URI

PCRE (PHP <7.3)
no description available
Submitted by anonymous - 3 years ago (Last modified 2 years ago)
0

Date Range

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

QDP - NoBcAl

PCRE2 (PHP >=7.3)
no description available
Submitted by anonymous - 3 years ago
0

WORD WRAP lines over 80 characters long

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

Add space after comma if it has letters on each side.

PCRE (PHP <7.3)
This is used in the SQL_Pretty_Formatter after the commas inside quotes, parenthesis, and brackets have been temporarily replaced with |.
Submitted by Ben - 3 years ago
0

Find all commas that are not in parenthesis. Used in SQL_Pretty_Format()

ECMAScript (JavaScript)
Find all commas that are not in parenthesis or square brackets.
Submitted by Ben - 3 years ago
0

Negative lookahead with example

PCRE (PHP <7.3)
This text won\'t match because it does contain ab in it! This text won\'t match because it does contain cd in it! This text matches because it doesn\'t contain them in itghdfgdfg!
Submitted by jarea - 3 years ago
1...622623624625626...765

Extract /24 (IPv4) or /64 (IPv6)

0

Regular Expression
PCRE (PHP <7.3)

/
^(?<srcNet>\d{1,3}\.\d{1,3}\.\d{1,3}|[0-9a-f]{1,4}:[0-9a-f]{1,4}:[0-9a-f]{1,4}:[0-9a-f]{1,4})[.:]
/
gim
Open regex in editor

Description

This extracts the first three octets of an IPv4 address, or the first half of an IPv6 address. This may be suitable for classifying addresses by address groups.

Submitted by anonymous - 6 years ago