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?
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
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…
Sam, I haven’t uploaded the latest version. I got busy, then sick, then busy again so it’s not ready for prime time yet. I’ll post it soon.
Hi!
Did the Regex version ever get posted?
Thanks!
Dave
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.
Hello just figured i would let you know i had a issue with this blog appearing frozen also. Must be chimpanzees in the system.