Regular Expressions 101

Community Patterns

Community Library Entry

1

Regular Expression
PCRE2 (PHP >=7.3)

/
^(.+)\s+(\d{2}\s?\d{3}|\d{5})\s+((?:\S+\s)*\S+)\s*(.*?)$
/
gm

Description

regEx used in VBA code to split french address into different columns in order to format more clearly

Submitted by Ropper - 8 months ago