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.

01-18-2005, 09:16 AM	#2
gstelmack Pro Starter Join Date: Oct 2000 Location: Cary, NC	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. __________________ -- Greg -- Author of various FOF utilities

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)