PDA

View Full Version : Getting text files to work in CSV format


maximus
01-18-2005, 01:17 AM
I know that you can import text files into excel and save as csv but I am having issues with getting all the info into separate cells. My goal is to print-to-file stats from FOF2004, convert to csv (so they look nice) and then build a database full of stats. How would I go about getting the text files I print from FOF2004 to look/ or convert nicely into csv/excel so that each stat, name, ect has it's own cell?

Thanks.

gstelmack
01-18-2005, 09:16 AM
Depends. They are fixed width, so you should just be able to mark the columns manually. However, some of the pages have columns that overflow, which messes with this.

I'd try the TCY/FOF HTML export utility which does a nice job putting the grid views into HTML tables, which should then be easy to bring into a database.