Supersearch

Extract City Name From Mailing Address Prompt

Outbound prompt for prospecting that standardizes city extraction from messy addresses. This prompt takes a full mailing address field and returns only the clean, properly capitalized city name. It removes punctuation and whitespace, enforces correct casing, and uses a strict fallback to “No data” when the city cannot be confidently identified. Ideal for B2B sales and marketing teams building clean location data for segmentation, routing, geo-personalization, and territory assignments. Insert it into your AI sales research workflow to normalize CRM inputs from web forms, enrichment vendors, list uploads, or scraped sources.Use cases include geo-targeted cold email campaigns, SDR territory mapping, account prioritization by metro area, and enriching company or contact records with reliable city fields. Because it outputs only the city with no labels or extra text, it slots directly into spreadsheets, data pipelines, or automations without post-processing. This B2B lead generation prompt reduces manual cleanup, improves match rates with third-party datasets, and powers accurate filters for event invites, field sales coverage, and regional case studies.Workflow highlights:- Input: full mailing address in a single field- Output: city only, standardized casing- Error handling: “No data” when unclear or missing- Ready for bulk processing, CSV workflows, and CRM enrichmentIf the original input is provided in another language, note that the final description is in English. The prompt still extracts the city and applies the same rules consistently.

AI Prompt Preview

You are given:{{property_1}} — a full mailing address, which may include street, city, state, postal code, and country.Your task is to extract only the city name from this address.Instructions:Return only the city — no street, state, zip code, or country.Strip punctuation and whitespace.Capitalize properly (e.g., “los angeles” → “Los Angeles”).Do not include any labels, filler, or quotation marks.Do not return a message, explanation, or placeholder response.Never ask for more input. You must always respond with a cleaned city name or No data.Fallback Rule:If the city is missing, unclear, or can’t be confidently extracted, return: No data

Use this prompt

0 runs

#Infrastructure
#Deliverability

Josh Whitfield

Sales Manager at ABC Media

“My template combines personalized messaging with a structured follow-up sequence that has proven to be very successful.”

Ready to put this prompt in action?

Use in Instantly

Share prompt:

Josh Whitfield

Sales Manager at ABC Media

“My template combines personalized messaging with a structured follow-up sequence that has proven to be very successful.”

Ready to put this prompt in action?

Use in Instantly

Share prompt:

Copied to clipboard

Start building your AI sales engine

Get started now to access exclusive templates and elevate your projects to the next level.

Stop letting poor deliverability kill your pipeline. Join 50,000+ sales teams who've made the switch to Instantly for better inbox placement, higher response rates, and more closed deals.

No credit card required.