Py.Cafe
Pattern Extraction and Logging Tool
- app.py
- mt_snf_lead_sf_int_lead_load_3.log
- requirements.txt
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
import re
import pandas as pd
# --- Step 1: Read text file ---
with open("mt_snf_lead_sf_int_lead_load_3.log", "r", encoding="utf-8") as f:
text = f.read()
# --- Step 2: Get patterns from user ---
patterns = [
r"Name:\s*(.*)",
r"Email:\s*(.*)",
r"Phone:\s*(.*)"
]
# --- Step 3: Extract results ---
results = {}
for pattern in patterns:
matches = re.findall(pattern, text)
results[pattern] = matches if matches else ["Not found"]
# --- Step 4: Convert to Excel ---
df = pd.DataFrame(dict([(k, pd.Series(v)) for k, v in results.items()]))
df.to_excel("output.xlsx", index=False)
print("Excel created successfully!")