Write a regex to clean a column

Get a tested pattern that finds or fixes messy values like phone numbers, codes or dates.

You'll attach

Text only

Works with

ChatGPTClaudeGeminiGrokCopilotGrok Bot

How to use it

1. Open chatgpt.com or claude.ai (or another AI listed here).
2. Fill in the highlighted blank ([EXAMPLES]) below, or edit them after pasting.
3. Copy the prompt, paste it into the chat and send.

I need a regular expression for [TOOL: Google Sheets / Excel / Python / JavaScript].

Goal: [WHAT TO MATCH OR FIX, e.g. pull 5-digit ZIP codes out of addresses].
Example values that SHOULD match: [EXAMPLES]
Example values that should NOT match: [EXAMPLES]

Give me:
1. The pattern, ready to paste into that tool (with the exact formula if it's a spreadsheet).
2. A piece-by-piece explanation in plain words.
3. A table testing it against every example above.
4. Edge cases it will miss.