Convert FOL database

I've been tasked with writing a utility to convert a FOL database (old DOS format) to some other format (CSV to start out probably).

I was just curious if anyone else had any experience with this format or if anyone has done this in the past. I'd rather not reinvent the wheel if possible.

I know it's probably just as simple as opening the file in binary, and digging through the lines taking piece by piece, but I was hoping to find someone here that has dealt with it.

Thanks in advance for anything.

Now that I think about it, this may need to be moved to the databases section. If a mod could kindly do so....

Moved from Classic VB forum. :)

*bump* anyone?

Quote:

---

Originally Posted by ober0330

*bump* anyone?

---

Sorry, I have no idea what a FOL database is. Searched for it on Google, but didn't find anything.

I guess you have to go with your idea to open it in a text or hex reader and see if you can get anything usefull out of that.

Try the FILE SYSTEM OBJECT - maybe it will recognize the "delimiter" of each line and make parsing easier. We've had good luck with FSO for converting files from other (non-PC) platforms.

some info (from yahoo) here

That is awesome Ecniv! It's a wonder I didn't find that when searching.

And yes, for the others, the database is actually called "First Choice", the the format is FOL.