Intelligently generate and explain regular expressions, supporting various common pattern matching
Convert your text instructions into formulas or input a formula to have it explained.
Edit Excel online by chatting with AI
Convert your text instructions into SQL queries - powered by AI.
Generate Excel VBA (Visual Basic for Applications) code to automate tasks and create custom solutions within Microsoft Excel.
Upload your Excel file and generate beautiful charts with our AI-powered chart generator.
Convert your text into beautiful mind maps with our AI-powered mind map generator. Edit and customize your mind maps easily.
Use AI to intelligently generate and explain regular expressions, supporting various text pattern matching and data validation.
Regular Expression (Regex) is a powerful pattern matching syntax for text search, extraction and replacement. It’s widely used in form validation, log analysis, data extraction, web crawling, and text processing.
For example:
All these can be easily done with regular expressions.
Symbol | Meaning |
---|---|
. |
Matches any character except newline |
^ |
Matches start of input |
$ |
Matches end of input |
* |
Matches preceding element 0+ times |
+ |
Matches preceding element 1+ times |
? |
Matches preceding element 0 or 1 time |
[] |
Matches any single character in brackets |
[^] |
Matches any character NOT in brackets |
{n} |
Matches exactly n times |
{n,} |
Matches n or more times |
{n,m} |
Matches between n and m times |
\d |
Matches any digit (0-9) |
\w |
Matches word character (a-z, A-Z, 0-9, _) |
\s |
Matches whitespace character |
` | ` |
() |
Grouping for extraction or reference |
^1[3-9]\d{9}$
^[\w.-]+@[\w.-]+\.\w+$
https?:\/\/(www\.)?[\w\-]+\.\w+(\.\w+)?(\/\S*)?
const regex = /\d{3}-\d{4}/;
const result = regex.test("123-4567"); // true
import re
match = re.search(r"\d{3}-\d{4}", "Number: 123-4567")