DJ Dunk

iTrader: (5)

Anyone got a free program/script/macro to batch convert a folder of delimited text files to Excel ? They are all space delimited files with the text qualified using quotes. Too much of a pain to do hundreds of them manually

Help ! Thanks.

bioforger

iTrader: (1)

Save the txt files as csv instead? Then u can open them up straight away in Excel without having to use the wizard.

DJ Dunk

iTrader: (5)

Won't work as they are not comma delimited, but space delimited, it just throws them all into one column. I inherited the files unfortunately, they're not of my making.

I managed it in the end using a similar method though. Used good old TextPad to replace all instances of " " in all files with a comma, then removed and spare quotes, renamed the extensions in DOS and jobs a good un Just means I have to save them all as xls files now, but at least it saves on the text import wizard palaver.

Hanslow

I was about to suggest doing some scripts to replace " " with "," then just load them in as CSV.... too late now

DJ Dunk

iTrader: (5)

Thanks anyway You know what is like, you come across a problem, post it up on SN and no sooner have you pressed 'Submit New Thread' it comes to you like a flash

Dracoro

You CAN do this in Excel without any amendments to the files. Open Excel then open the file and by default, use the text import wizard using space as the delimiter and field qualifiers as "" if need be.

If you've already got it in excel in one column, you can still do the same thing. Use the menu: Data>Text to columns. They are one and the same thing as the text import wizard really.

And it DOES work as I've just tested it.

DJ Dunk

iTrader: (5)

Of course, but the problem was that I don't fancy doing that 119 times There are lots of files so using the text import wizard is a pain. MS haven't updated the crappy wizard since I started with Excel 4 It does the job, but needs batch processing.