Regular Expressions

[bulat]

Find examples and share your regular expressions here.

[bulat]

Here are a couple of regular expressions for UK customer data that I find useful for marketing files validation:

UK Postcode (From BS7666 Address):

Code: Select all

^(GIR 0AA|[A-PR-UWYZ]([0-9]{1,2}|([A-HK-Y][0-9]|[A-HK-Y][0-9]([0-9]|[ABEHMNPRV-Y]))|[0-9][A-HJKS-UW]) [0-9][ABD-HJLNP-UW-Z]{2})$


UK Postcode (simplified version):

Code: Select all

^[A-Z]{1,2}[0-9R][0-9A-Z]?\s[0-9][A-Z]{2}$

Email:

Code: Select all

^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}$

UK Telephone Number (including mobile):

Code: Select all

^(\+44)?(0|\(0\))[12378](\d[\-\(\)\.]?\s?){8,9}$

Matches: +44(0)1222333444; 02222333444; 0(1222) 333-444

UK Mobile Number:

Code: Select all

^(\+44)?(0|\(0\))7(\d[\-\(\)\.]?\s?){9}$

Surname (Now matches Irish and Scottish surnames) :

Code: Select all

^[A-Z]([']|[a-z]{0,2})?[A-Z]?[a-z]+((\s|\-)[A-Z][a-zA-Z]+){0,2}$

[bulat]

Zip Code (5/5+4 formats):

Code: Select all

^(\d{5})(-\d{4})?$

[bulat]

Postcode:

Code: Select all

^[ABCEGHJKLMNPRSTVXY]\d[A-Z] \d[A-Z]\d$

[bulat]

MAC Address:

Code: Select all

([0-9a-fA-F][0-9a-fA-F]){5}([0-9a-fA-F][0-9a-fA-F])

Date:

Code: Select all

^((((0?[1-9]|[12]\d|3[01])[\.\-\/](0?[13578]|1[02])[\.\-\/]((1[6-9]|[2-9]\d)?\d{2}))|((0?[1-9]|[12]\d|30)[\.\-\/](0?[13456789]|1[012])[\.\-\/]((1[6-9]|[2-9]\d)?\d{2}))|((0?[1-9]|1\d|2[0-8])[\.\-\/]0?2[\.\-\/]((1[6-9]|[2-9]\d)?\d{2}))|(29[\.\-\/]0?2[\.\-\/]((1[6-9]|[2-9]\d)?(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00)|00)))|(((0[1-9]|[12]\d|3[01])(0[13578]|1[02])((1[6-9]|[2-9]\d)?\d{2}))|((0[1-9]|[12]\d|30)(0[13456789]|1[012])((1[6-9]|[2-9]\d)?\d{2}))|((0[1-9]|1\d|2[0-8])02((1[6-9]|[2-9]\d)?\d{2}))|(2902((1[6-9]|[2-9]\d)?(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00)|00))))$

UPD (Bulat): I would not recommend using regular expressions for date validation. It is better to set a date range through Value data rule and specify date format in the Field Details form.