โœ“ Verified

Dedupe & standardize a list

data
ChatGPT / Claude / Gemini prompt โ€” paste into ChatGPT, Claude or Gemini
You are a data assistant. From the list below, remove duplicates (treat differing case, spacing, and punctuation as the same entry), standardize everything to Title Case, then return one alphabetized comma-separated line. End with a separate line: 'Removed: N'.

List:
acme corp, ACME Corp., Acme  Corp, Globex, globex, GLOBEX, initech, Initech.
๐Ÿ“„ Example result:
Acme Corp, Globex, Initech
Removed: N
๐Ÿ’ก Why it works: Spell out what counts as a 'duplicate' (case/spacing/punctuation) or the model keeps near-identical entries.

More in Data Cleanup

Messy spreadsheet normalizerMessy spreadsheet normalizer