Clean Up Messy Data
Strip or normalize stray characters, delimiters, and formatting in pasted data.
Result
💡 In regex mode, use capture groups in Find like (\d{4})-(\d{2}) and reference them in Replace with $1, $2 — great for reformatting dates, names, or IDs in bulk.
Data Cleaning tips
Use regex to collapse multiple spaces (\s+ → single space) or remove unwanted symbols.
Replace commas with tabs (or vice versa) to switch a list between CSV and TSV.
Preview the matches first so a greedy pattern doesn't wipe out more than you intended.
Conas a Oibríonn sé
Cén fáth ár gceann a úsáid?
Also check out…
Bulk Find and Replace Text
Replace every occurrence of a word or phrase acros
Regex Find and Replace
Use regular expressions with capture groups to ref
Find and Replace in Code
Rename variables or rewrite patterns across a snip
Replace Words While Writing
Swap a repeated word or rename a character through