[olug] Database export problem

[Eric Lusk]

Well, I'm trying to keep the fields in place, but may
wind up just pulling the data out and re-creating the
fields....  Going to be a long weekend, it looks like.

--- Tim Russell <philodux at yahoo.com> wrote:

> Eric,
> 
> If you know, for example, what data is contained in
> the file (for example, the first row, or the first
> couple of rows), it shouldn't take much to reverse
> the
> file - assuming, of course, you're just after data
> and
> not interested in maintaining anything else out of
> the
> database (relationships, etc).  Being a programmer,
> my
> first instinct is to reach for the compiler.
> 
> For example, if you know the first row contains
> Name,
> address, and phone number, and you can reasonably
> find
> those fields within the file, you should be able to
> write a program that can scan and extract the data
> you
> want.
> 
> Then again, the file format might be way more
> complicated than I'm guessing at, and I just don't
> know what I'm talking about =)  This is occasionally
> the case =).
> 
> - tim 
> 
> --- Eric Lusk <wyrmzr72 at yahoo.com> wrote:
> 
> > I'm trying to export a proprietary database format
> > so
> > that it can be read by Excel.  The standard format
> > of
> > the database files gives lots of garbage from
> > carriage
> > returns, spaces, etc., in Linux or Windoze.
> > The program itself has an export option, but that
> > only
> > exports 3-4 fields to an tab-delimited file.  I'm
> > going to try and modify the export options tonight
> > and
> > keep my fingers crossed.
> > Anyone else have any ideas about removing the
> > garbage
> > from a proprietary file?  I dread telling the
> client
> > they'll have to manually input 9000 clients....
> > TIA
> > 
> > 
> > 
> > http://www.ericshaus.com
> > Alcohol and Calculus don't mix.  Never drink and
> > derive.
> > 
> > 
> > 		
> > __________________________________ 
> > Yahoo! Mail - PC Magazine Editors' Choice 2005 
> > http://mail.yahoo.com
> > _______________________________________________
> > OLUG mailing list
> > OLUG at olug.org
> > http://lists.olug.org/mailman/listinfo/olug
> > 
> 
> 
> 
> 		
> __________________________________ 
> Yahoo! Mail - PC Magazine Editors' Choice 2005 
> http://mail.yahoo.com
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug
> 


http://www.ericshaus.com
Alcohol and Calculus don't mix.  Never drink and derive.


		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com