I was trying to get a list of file names from a list of paths I had in column A. I used
Data - Text to Columns delimited on “\”. The results are below. I highlighted the file names so you could see my problem.
There were only a dozen or so paths, so it didn’t take long to get all the file names in the same column. But it got me thinking about a right-to-left feature for TTC. I have one more instance where it would be useful. In Quickbooks, the inventory items’ full names look like this:
A right-to-left feature would be useful there too. As I started planning out this utility (that means I was really looking at the built-in feature to copy what I could), I couldn’t help notice some features I never use. First, there is no reason this needs to be a three form wizard – it should all be on one form. Second, I very rarely set the column data types, just accepting General. Last, I never noticed the Destination refedit on the last form. Only when I took a hard look at this process did I notice it was there. Seems like a fairly useful feature, but I haven’t used it 25 years.
I’ve been enjoying my DDoE Quick Find so much lately, I decided to make a Quick TTC utility that got rid of the crap and added the right-to-left feature. Here’s what I ended up with.
Some features include:
- No wizard. It’s all on one screen
- Right to left option as shown above
- Custom delimiters (there’s two) can be multiple characters
- No field types, no destination option
I’ll be blogging about some of the code later this week, but if you want to check it out on your own and can download DDoEQuickTTC.zip. It’s in serious BETA, so use at your own risk.