Regex Tester
Test and debug regular expressions for data transformation and validation
0
Matches
0
Groups
Common Patterns for Data Engineering
Email Validation
Match valid email addresses
^[\w.-]+@[\w.-]+\.\w+$
IP Address
Match IPv4 addresses
\b(?:25[0-5]|...)
ISO Date (YYYY-MM-DD)
Match ISO date format
^\d{4}-\d{2}-\d{2}$
URL
Match HTTP/HTTPS URLs
^(?:http|https)://...
UUID
Match UUID/GUID
^[0-9a-fA-F]{8}-...
Currency
Match currency amounts
^\$?[0-9]{1,3}(,[0-9]{3})*...
Acronyms
Extract uppercase acronyms
\b[A-Z]{2,}\b
SQL SELECT
Match SQL SELECT statements
SELECT.*?FROM.*?...
Thousands Separator
Match numbers with . separator
\b\d{1,3}(\.\d{3})*\b
Username
Validate usernames
^[a-zA-Z0-9_-]{3,16}$