in reply to Baffled by data cleaning regex issue

Are you wondering why there are trailing spaces? I'm guessing it's because you started with '"096  "'.