Text to Columns Regular Expressions

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?

Posted in Uncategorized

6 thoughts on “Text to Columns Regular Expressions

  1. With respect, Dick, the UI wouldn’t be so gigantic if you didn’t habitually leave such huge spaces both between your controls and at the edges of your dialog. I also think your results list has a few too many rows. Otherwise, it’s fine. Add any more functionality, though, and you’re going to get yourself in trouble ;-)

  2. Dick, I did not find this feature in the Addin that I downloaded….Is there an updated link – The regular expression is a great idea

    By the way I never really understood what “Treat consecutive Delimiters as one” does…

  3. Ooh dang i just wrote a big comment and when i hit post it come up blank! Please please tell me it worked right? I do not want to sumit it again if i dont have to! Either the blog bugged out or i am an idiot, the latter doesnt surprise me lol.


Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published. Required fields are marked *