OK, I lied. One more post about TTC. I’ve added RegEx. When I use Text-to-Columns, it’s always for a one-off job. I have a goofy string and I need to get one piece of information out of the middle. It’s never part of a periodic process and I never call it in code. A few days after I set this up so I could use the right to left behavior, I ran into another situation. There were social security numbers in the middle of a continuous string (no delimiters). In the interest of feature-creep, I added regular expressions to my Quick TTC.
I think the problem is pretty obvious. OK, other than the gigantic user interface, I think the problem is pretty obvious: I need more built-in regular expressions. I think a dozen would be nice. So what regex patterns should I add?