More efficient way to clean a column of strings and add a new column

Was a -3 question in which I answered and has subsequently become a 3+ question along with my answer becoming 5+.

Are there other criteria that aren't listed? Is it possible the periodic criteria checker has skipped it for some reason?

  • That's weird... maybe caching? Jan 1, 2017 at 16:43
  • The timeline shows only two downvotes, but there might be another one which was retracted on the same day.
    – Glorfindel Mod
    Jan 1, 2017 at 16:44
  • @Glorfindel On the same day you say? Yeah, that was probably mine. I downvoted, then edited, then upvoted. Is that something that you'd think is not in the spirit of the criteria? If so, I'll try again. But I thought by the letter of the "law" I nailed it.
    – piRSquared
    Jan 1, 2017 at 16:45
  • @piRSquared I don't know, I'm just pointing to a possible cause.
    – Glorfindel Mod
    Jan 1, 2017 at 16:46
  • @Glorfindel I get it, and I appreciate the suggestion.
    – piRSquared
    Jan 1, 2017 at 16:47

2 Answers 2


According to the timeline, that question had a total of zero votes on it at the time you posted your answer. The three downvotes came in later, one of which was yours that you retracted. However, the hat is not for just having an answer on a -3 question that becomes +3 - the answer needs to be posted after it was already at -3. The theory of the hat is that your answer turned the question around, similar to the Reversal badge. Your answer there would have never qualified for the hat regardless of the votes that came in later.

  • That makes sense. And now I know!
    – piRSquared
    Jan 1, 2017 at 20:55

Ah, because it was never reached -3 in the first place (I'm talking about the question). If you can see its vote counts, it says +7/-2:

enter image description here

Probably by the time the hat checker came by, someone retracted their downvote so the lowest it can possibly be is actually -2. Since the question needs to be at -3 at one point, you couldn't get the hat.

  • !BaH! Your are probably right. And that was my vote that was retracted as well. So I didn't let it sit at -3 long enough
    – piRSquared
    Jan 1, 2017 at 16:48
  • 3
    @piRSquared Well fooled yourself eh Jan 1, 2017 at 16:50
  • Yes! I certainly did.
    – piRSquared
    Jan 1, 2017 at 16:51
  • Oh! I will ;-). 4 minutes or so
    – piRSquared
    Jan 1, 2017 at 16:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .