Text Data Extraction
Extracts structured data from unstructured text using patterns
Help extract data from text.
Text/example:
{text}
What to extract: {data} (email / phone numbers / dates / amounts / full names / URLs / custom)
Output format: {format} (list / CSV / JSON / table)
Output:
1. **Regex pattern** with explanation of each part
2. **Python script** (re + pandas):
- Find all matches
- Save in structured format
- Handle edge cases
3. **Google Sheets alternative**: REGEXEXTRACT formulas
4. **Test examples**: what it will find and what it will miss
5. **Edge cases**: potential issues and their solutions
If data is heterogeneous (different phone/date formats), account for all variations.
0 copies
Variables
Replace these variables with your own values before using:
{текст}{данные}{формат}
Prompt info
📊
Category
Data
AI model
Any model
Application
Извлечение структурированных данных из текстов, документов, логов
парсингregexизвлечение данныхтекставтоматизация
Similar prompts
RegEx Data Extractor
Extracts data using regular expressions with match explanations
Format: Regex pattern with examples and explanation. Context: You create regex p...
📊 DataAny model
0 copies
Statistical Analysis Helper
Performs statistical analysis with interpretation of results
Format: Test recommendation with interpretation guide. Context: You recommend st...
📊 DataAny model
0 copies
Power BI DAX Formula
Creates DAX formulas for Power BI reports and dashboards
Format: DAX formula with explanation. Context: You write Power BI DAX formulas. ...
📊 DataAny model
0 copies