Unstructured to Structured NER Prompt

Initial prompt:
===============

Objective:

Extract structured contact information from the provided unformatted text and convert it into CSV format with specified columns. Capture all available information, even if some fields are missing. Format all phone numbers as (XXX) XXX-XXXX and ensure city and state are captured separately from the address.

Columns to Extract:

- Name: Full name of the person (e.g., "John Doe")
- Email: Email address of the person (e.g., "[email protected]")
- Phone: Phone number formatted as "(XXX) XXX-XXXX" (e.g., "(555) 123-4567")
- Address: Street address without city, state, or ZIP (e.g., "432 Oak St")
- City: Full city name (e.g., "Springfield")
- State: Two-letter state abbreviation (e.g., "IL")
- Zip: Postal ZIP code (e.g., "60901")

Instructions:

1. Read the Unformatted Text Carefully: Identify and extract each piece of information based on common patterns and keywords.

2. Use Patterns for Extraction:
   - Phone Numbers: Look for patterns like "(XXX) XXX-XXXX" or "XXX-XXX-XXXX" and reformat to "(XXX) XXX-XXXX".
   - Email Addresses: Identify email patterns using "[email protected]".
   - Addresses: Extract street addresses and separate them from city, state, and ZIP code information.

3. Identify Keywords and Phrases:
   - Use common indicators like Email:, Phone:, Address:, City:, State:, and ZIP: to locate relevant data.

4. Format Data into CSV:
   - Enclose each field in double quotes.
   - Separate fields with commas.
   - Ensure no extra spaces around commas.

5. Handle Missing Data:
   - Leave fields blank if no information is available.
   - Include city and state if known, even if other fields are blank.

Error Handling:

- Flag Entries for Review: Identify entries with incomplete data for manual review.
- Correct Misplaced or Incorrect Data: Adjust any misplaced data or incorrect formatting according to the specified rules.

Example:

Given the unformatted text:

John Doe - [email protected]
(555) 123-4567
432 Oak St, Springfield, IL

The extracted CSV should be:

"Name","Email","Phone","Address","City","State","Zip"
"John Doe","[email protected]","(555) 123-4567","432 Oak St","Springfield","IL",""

Data to process:

[unstructured data]



Followup prompt:
================

Review each line carefully referring back to the original data correcting all errors and omissions.