Re: Excel spreadsheet matrix into Octave using clipboard?

[Mike Miller]

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
-------------------------------------------------------------