Regular Expressions 101

Community Patterns

New Excel RegEx

0

Regular Expression
PCRE (PHP <7.3)

/
((\[.*\])?(('(?:[^']|'')*'!)|([a-zA-Z0-9_]+!)))?((\$?[a-z]{1,3}\$?[0-9]{1,7})(\:\$?[a-z]{1,3}\$?[0-9]{1,7})?|\$?[a-z]{1,3}\:\$?[a-z]{1,3}|\$?[0-9]{1,7}\:\$?[0-9]{1,7})
/
gmi

Description

Trying new excel reg ex based off of one from stack overflow with modifications

Submitted by anonymous - 3 years ago