Phone Number Fixer

😫 The Pain Point

Your contact list has phone numbers in 10 different formats: “0901234567”, “84-90-123-4567”, “+84 90 123 4567”, “090 123 4567”. You need them all standardized for SMS marketing.

🚀 Agentic Solution

A Phone Number Normalizer that converts all formats to your standard.

Key Features:

• Format Options: E.164 (+84901234567), National (0901234567), Spaced.
• Validation: Check if numbers are valid.
• Country Detection: Auto-detect or force country code.

⚔️ Phase 1: Commander (Quick Fix)

For quick formatting.

Prompt:

“I have an Excel contacts.xlsx with column ‘Phone’ containing Vietnamese phone numbers in various formats. Write a Python script using phonenumbers library to:

1. Parse: Assume Vietnam (+84) if no country code.
2. Format: Standardize to 84xxxxxxxxx (no plus, no spaces).
3. Validate: Mark invalid numbers in a new column.
4. Output: Save as contacts_fixed.xlsx.

Print count of valid/invalid numbers.”

Result: Clean phone list ready for bulk SMS.

🏗️ Phase 2: Architect (Permanent Tool)

Engineering Prompt:

**Role:** Python Tool Developer
**Task:** Create a "Phone Number Formatter".

**Requirements:**
1.  **GUI:**
    *   Select Excel file.
    *   Column picker.
    *   Country dropdown (default Vietnam).
    *   Output format dropdown.
    *   Preview valid/invalid.

2.  **Logic:**
    *   Use phonenumbers library.
    *   Handle edge cases (landlines, mobile).
    *   Mark invalid without deleting.

3.  **Deliverables:**
    *   `phone_fixer.py`
    *   `run.bat`, `run.sh`
    *   `requirements.txt`

🧠 Prompt Decoding

• phonenumbers library: Google’s library that handles all international formats.

🛠️ Instructions

1. Install: pip install phonenumbers
2. Copy Prompt → Run.