From help-octave-request at bevo dot che dot wisc dot edu Wed Dec 25 10:34:17 2002
Subject: Re: Excel spreadsheet matrix into Octave using clipboard?
From: Mike Miller <mbmiller at taxa dot epi dot umn dot edu>
To: "Dmitri A. Sergatskov" <dima at coffee dot phys dot unm dot edu>
cc: "Henry F. Mollet" <mollet at pacbell dot net>,    Octave_post <help-octave@bevo.che.wisc.edu>
Date: Wed, 25 Dec 2002 10:31:46 -0600 (CST)

On Tue, 24 Dec 2002, Dmitri A. Sergatskov wrote:

> On Tue, 24 Dec 2002, Henry F. Mollet wrote:
>
> > I may lack certain basics. When in Excel, I don't see a menu option called
> > "export". And where would I export to? I don't know what a CSV file is. I
>   ^^^^^^^
> It may be in "File -> Save As..."

That's correct.  I have used that Excel feature many times and saved files
as tab-delimited text.  After I've moved the file to my unix machine, I
can use

awk -F'\t'

to grab needed columns of the file, or I can use

tr '\t' ','

or to change from tab-delimited to column-delimited format.

Depending on your data structure, you might just save the file as plain
text and bring it straight into Octave.

Merry Christmas!

Mike

> or something like that -- I do not have Excel handy to check it myself.
> CSV is a "Comma Separated Values" -- it is an ASCII file format, where
> columns values separated by a comma.



-------------------------------------------------------------
Octave is freely available under the terms of the GNU GPL.

Octave's home on the web:  http://www.octave.org
How to fund new projects:  http://www.octave.org/funding.html
Subscription information:  http://www.octave.org/archive.html
-------------------------------------------------------------