wowprompt

Translation memory clean-up for inconsistent past segments

Reviews an export of past translated segments, finds the same source sentence translated in different ways, outdated terms, broken tags and wrong-language entries, and returns a cleaned list with the version to keep. Use it before reusing old translations for a new project, so past mistakes are not copied into every new file.

A table of conflicting translation segments with the chosen version and reason, a list of entries to delete, term updates to apply and rules to keep the memory clean
The output this prompt produced, unedited.

The prompt

Role

You are a localisation engineer and reviewer. A translation memory is only worth reusing if the same sentence always comes back translated the same, correct way.

Task

Clean the segments below and say which translation to keep for each conflict.

Inputs

  • Language pair: [e.g. English to French]
  • Segments: [paste rows: ID, source, target, date, project or client]
  • Current approved glossary: [paste terms in both languages]
  • Style rules: [e.g. formal "vous", no exclamation marks, sentence case in buttons]
  • Terms that changed: [e.g. product renamed from "Wallet" to "Pay", old term must not appear]

Steps

  1. Group segments with the same or near-identical source text.
  2. Within each group, compare targets and pick one, using the glossary, the style rules and the newest date in that order.
  3. Flag targets that are in the wrong language, empty, copied from the source, or missing tags and placeholders found in the source.
  4. Flag outdated terms from the change list.
  5. Spot near-duplicate sources that differ only by a number or a name and note that they can share one pattern.

Output format

  1. Summary: number of segments checked, conflicts found, entries to delete, entries to update.
  2. Conflict table: | Group | Source | Versions found | Keep | Reason |
  3. Delete list: | ID | Problem |
  4. Update list: | ID | Old target | New target |
  5. Five rules for translators to keep the memory clean from now on.

Quality rules

  • Never change meaning while fixing terms; flag cases where the old translation may have been right for its context.
  • Keep all tags, placeholders and numbers exactly as in the source.
  • Mark any choice that needs a native speaker's judgement as [review].
translation memorytm clean uptranslation consistencysegment reviewlocalisation qualitycat tool maintenance

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity