I realize that, but my end solution is a fixed width format. Excel can also do that but I was looking for something a little more automated and easier. It's a lot easier/faster to take an excel/csv file and type convert filename.csv and get a nice fixed width file that I can work with.
Also, some of the files I'm dealing with that are already CSV are 800-1000 lines, and Open/StarOffice and Excel have a limit of 65k > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Chris > Sent: Wednesday, January 08, 2003 12:22 PM > To: Jerry Feldman > Cc: [EMAIL PROTECTED] > Subject: Re: Data conversion > > > Excel can save as CSV just go to file/save as and select the format > > > Jerry Feldman wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Content-Type: text/plain; charset=us-ascii > > > > You might look at OpenOffice.org. It's calc module reads > (and writes > > Excel spread sheets which you can save to dBASE or CSV > format. "Travis > > Roy" wrote: > > > Hi, I'm looking for two things, they might both be in the same > > > package, but I can't find either, at least from a command line. > > > > > > I'm looking to convert something from Excel to CSV and > then from CSV > > > to fixed with or "Standard Data Format" as dBase calls > it.. Example: > > > > > > FirstN LastN EMail > > > Travis Roy [EMAIL PROTECTED] > > > Joe Bob [EMAIL PROTECTED] > > > > > > > > > Has anybody heard of anything like this for the console > for Linux? > > > I've been searching and can't find anything. > > > _______________________________________________ > > > gnhlug-discuss mailing list > > > [EMAIL PROTECTED] > > > http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss > > > > > > > - -- > > Jerry Feldman <[EMAIL PROTECTED]> > > Boston Linux and Unix user group > > http://www.blu.org PGP key id:C5061EA9 > > PGP Key fingerprint:053C 73EC 3AC1 5C44 3E14 9245 FB00 3ED5 > C506 1EA9 > > > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG v1.2.1 (GNU/Linux) > > Comment: Exmh version 2.5 12/25/2001 > > > > iD8DBQE+HDdw+wA+1cUGHqkRAqF3AKCD/MQ0fhj69ADFRgKC3KafbRW9nwCfb3Oj > > QJ1MwktfsOfWDf6oiXYV6Bo= > > =O/OV > > -----END PGP SIGNATURE----- > > > > _______________________________________________ > > gnhlug-discuss mailing list > > [EMAIL PROTECTED] > > http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss > > _______________________________________________ > gnhlug-discuss mailing list > [EMAIL PROTECTED] > http://mail.gnhlug.org/mailman/listinfo/gnhlug> -discuss > _______________________________________________ gnhlug-discuss mailing list [EMAIL PROTECTED] http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss