Regex Formula Library
Browse ready-to-use formula templates for Excel, Google Sheets, SQL, and regex. Each formula includes a step-by-step breakdown, edge-case warnings, and real-world examples.
AI-generated regex patterns with validation. Extract emails, numbers, URLs, and more from unstructured text.
Extract Email Addresses
A battle-tested regex pattern for finding email addresses in unstructured text. Handles common formats and edge cases.
Extract Numbers From Text
Pull numbers out of messy text data — prices, measurements, IDs, or any numeric value embedded in strings.
IP Address Regex
Match and validate IPv4 addresses in text. From quick-and-dirty patterns to strict 0-255 range validation.
URL Extraction Regex
Find and extract URLs from unstructured text. Match full URLs, domains, or specific URL components with tested patterns.
Password Validation Regex
Enforce password strength rules with regex. Minimum length, character requirements, and common patterns for registration forms.
Email Address Validation
Ensuring that email addresses are correctly formatted is crucial for data integrity. This regex pattern helps you validate email formats reliably.
US Phone Number Regex
Matching US phone numbers can be tricky due to various formats. This regex pattern simplifies the process by capturing multiple formats.
Extract URLs from Text
Extracting URLs from text can be challenging, but with the right regex pattern, you can easily find and list them all.
Match Date Formats
Matching dates can be tricky due to various formats. This regex pattern helps you capture MM/DD/YYYY, YYYY-MM-DD, and DD Month YYYY formats seamlessly.
Validate IPv4 Address
Validating an IPv4 address can be tricky, but using regex makes it straightforward by ensuring each octet is within the correct range.
Match US ZIP Codes
Understanding ZIP code formats is essential for data validation. This regex pattern helps you accurately identify both standard and extended ZIP codes.
Extract Names and Domain
Named capture groups simplify extracting specific data from strings, making it easier to retrieve first names, last names, and domains.
Understanding Regex Lookahead
Regex lookahead assertions allow you to match a word only when it is followed or not followed by a specific pattern, enhancing your text processing capabilities.
Match Whole Words with Regex
Using word boundary anchors in regex allows you to match complete words, ensuring no partial matches occur. This is essential for accurate text processing.
Using Backreferences in Regex
Backreferences allow you to refer to previously matched groups, making it easier to validate repeated patterns or matching tags.
Multiline Regex Patterns
Matching patterns that span multiple lines can be tricky, but using the right anchors can simplify the process significantly.
Extract HTML Content Non-Greedy
Using non-greedy matching in regex can help you accurately extract content between HTML tags without capturing too much data.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate it, explain it, and validate it — instantly.