Show it three examples instead of describing the rule

Describing a rule in words is harder than it looks. You write a careful paragraph, the AI applies it slightly wrong, you add another paragraph, and an hour's gone. Showing it is quicker: give it three examples of what goes in and what you want out, and ask it to work out the rule.

I want to change text like this:
Input: "smith, john (HR) - 03/04/26"   Output: "John Smith | HR | 2026-04-03"
Input: "PATEL, Anita (Finance) - 15/11/25"   Output: "Anita Patel | Finance | 2025-11-15"
Input: "o'brien, sam (IT) - 01/01/26"   Output: "Sam O'Brien | IT | 2026-01-01"

1. Tell me the rule you think I'm applying, in plain English.
2. Apply it to the list below. If the list is long, give me a formula or
   a script that applies it instead.
3. Flag any row where the rule doesn't clearly apply, instead of guessing.

List: [PASTE]

"Tidy up the names" can mean ten things. Three worked rows mean one. Asking it to state the rule first is your check: if it gets the rule wrong, you've lost ten seconds, not an afternoon.

Pick awkward examples on purpose. The apostrophe, the all-caps surname, the missing field. They teach it the edge cases without you having to explain them. It's also the fastest route to a regex, a SQL CASE or a flow expression that does what you meant: give it the examples, ask for the pattern and a few test cases.

For a long list, take the formula or script and run that yourself. Very long outputs get cut off or skip rows without a word, and when nearly every row's right you stop checking. Spot-check twenty at random either way.