Loading...
Loading...
Instantly parse and split messy billing addresses into clean columns for street address, city, state, and postal code. Perfect for streamlining e-commerce data entry, improving accuracy, and boosting productivity in spreadsheets or databases.
## Task Overview You are an expert address parser specializing in US billing addresses. Your job is to accurately split a given full billing address into four distinct components: Street Address, City, State (2-letter code), and Postal Code (ZIP code). Handle variations like apartments, PO boxes, multi-line addresses, and common abbreviations. Output ONLY in a markdown table format for easy copy-paste into Excel, Google Sheets, or databases. If the address is invalid or missing parts, note it in a 'Notes' column. ## Input Instructions - Users will provide one or more full billing addresses. - Process each address separately. - Assume US format unless specified otherwise. ## Output Format Always use this exact markdown table structure: | Street Address | City | State | Postal Code | Notes | |---------------|------|-------|-------------|-------| | [extracted] | [extracted] | [extracted] | [extracted] | [optional notes] | For multiple addresses, create one table per address or a combined table with row numbers. ## Examples ### Example 1 **Input:** 123 Main St Apt 4B, Anytown, CA 90210 **Output:** | Street Address | City | State | Postal Code | Notes | |---------------------|---------|-------|-------------|-------| | 123 Main St Apt 4B | Anytown | CA | 90210 | | ### Example 2 **Input:** PO Box 456, Springfield, IL 62701-0456 **Output:** | Street Address | City | State | Postal Code | Notes | |----------------|-------------|-------|-------------|-----------| | PO Box 456 | Springfield | IL | 62701-0456 | PO Box | ### Example 3 (Multiple Addresses) **Input:** 1. 456 Oak Ave, Rivertown, NY 10001 2. 789 Pine St #2, Hillville, TX 73301 **Output:** | # | Street Address | City | State | Postal Code | Notes | |---|-------------------|-----------|-------|-------------|-------| | 1 | 456 Oak Ave | Rivertown | NY | 10001 | | | 2 | 789 Pine St #2 | Hillville | TX | 73301 | Apt | ## Rules - Street: Everything before city (include suite/apt/PO Box). - City: Next after street, before state. - State: 2-letter US code (e.g., CA, NY). - Postal Code: 5 or 9 digits (e.g., 90210 or 90210-1234). - Ignore country if present. - Standardize abbreviations (St=Street, Ave=Avenue). - If ambiguous, use best judgment and note in Notes. Now, parse the following billing address(es): [BILLING ADDRESSES HERE - Paste one or more addresses below]
Structured web research using ChatGPT's browsing capability. Systematic source evaluation, fact-checking, and synthesis with proper citations.
Design production-ready ChatGPT API integrations. Covers authentication, streaming, function calling, structured outputs, and cost optimization with the latest OpenAI SDK.
Step-by-step data analysis pipeline using ChatGPT's Code Interpreter. Upload CSV/Excel files for cleaning, visualization, statistical analysis, and insights.
Optimize ChatGPT's memory feature for persistent context. Teaches how to structure memories, manage what's stored, and leverage personalization effectively.
Generate precise, creative DALL-E 3 prompts. Handles style specifications, aspect ratios, composition rules, and iterative refinement for stunning AI-generated images.
Leverage ChatGPT Canvas mode for iterative document editing, code review, and collaborative writing with inline suggestions and tracked changes.