Skip to content AI News: Claude Code's "don't ask again" put 1,379 secrets on GitHub: check your repos →
PH-1109 · Code prompt

Field Extraction That Returns Null, Not Guesses

Pulls the fields you name from an invoice, email or contract into JSON, sets a field to null when the text doesn't state it, and quotes the source words for every value. Use it when a guessed amount, date or account name would do more harm than an empty cell.

What you get

Pulls the fields you name from an invoice, email or contract into JSON, sets a field to null when the text doesn't state it, and quotes the source words for every value.

What you need
  • 2 blanks to fill in: field name and what it means paste the text
Best inAny chat modelAlso works in ChatGPT, Claude, Gemini
216 words
Prompt · November 10, 2026
I want you to act as a data extraction tool that would rather leave a field empty than guess. I'll give you a list of fields and a text, such as an invoice, an email, a contract or a web page.

Fields to extract, one per line, each with what it means:
[field name and what it means]

Rules:
- Use only what's written in the text. No outside knowledge, no inferring from context, no default values.
- If a field isn't clearly stated, set it to null.
- If the text gives two different values for the same field, set it to null and record the conflict.
- Dates as YYYY-MM-DD. Amounts as plain numbers, with the currency in a field of its own. Names exactly as written.

Return only valid JSON, with nothing before or after it, using three keys:
- "data": one key per field, holding the value or null
- "evidence": for every field that isn't null, the exact words from the text it came from
- "issues": a list of short notes on conflicts, and on any field you left null because the wording was unclear

If I paste several documents, return one such object per document, in a list, in the order I gave them.

The text:
[paste the text]
Data & Analytics Coding

How to use it

  1. Fill the blanks under «Make it yours» — the prompt updates as you type.
  2. Copy the prompt and paste it into ChatGPT, Claude or Gemini.
  3. Not quite right? Reply with what to change — the model keeps the rest.

More prompts like this

PH-0654Data & Analytics

Data Cleaning Assistant

Paste a sample of your spreadsheet or CSV and get a numbered cleaning checklist with exact steps and formulas to fix messy data before analysis.

You fill in Excel, Google Sheets…paste your rows here

ChatGPT · Claude · Gemini
PH-0752Business

Decision Log Extractor

Turns a long meeting transcript into a decision log with owners, deadlines and a quote behind every entry.

You fill in paste your transcript herenames and rolesproject name

Claude
PH-1099Productivity

Action Items With Proof

Turn a meeting transcript into action items where every item quotes the line it came from, owners and dates are taken only from what was said…

You fill in what it was aboutnames or rolespaste transcript or notes

ChatGPT · Claude · Gemini
PH-0933Data & Analytics

Spreadsheet Data Analyst

Turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.

You fill in 2024 sales exportonline homeware shopwhich products and months…

Gemini
Weekly

New prompts in your inbox

One email a week: the best new prompts and one short guide. Confirm by email and get the free Prompt Cheat Sheet (PDF). Unsubscribe any time. Privacy policy