Data conversion

[Travis Roy]

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: gnhlug-discuss-admin at mail.gnhlug.org 
> [mailto:gnhlug-discuss-admin at mail.gnhlug.org] On Behalf Of Chris
> Sent: Wednesday, January 08, 2003 12:22 PM
> To: Jerry Feldman
> Cc: discuss at gnhlug.org
> 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        travis at scootz.net
> > > Joe        Bob        joe at bob.com
> > >
> > >
> > > 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
> > > gnhlug-discuss at mail.gnhlug.org 
> > > http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
> > >
> >
> > - --
> > Jerry Feldman <gaf at blu.org>
> > 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
> > gnhlug-discuss at mail.gnhlug.org 
> > http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
> 
> _______________________________________________
> gnhlug-discuss mailing list
> gnhlug-discuss at mail.gnhlug.org 
> http://mail.gnhlug.org/mailman/listinfo/gnhlug> -discuss
>