Re: 3d Matrices to ASCII

[Joao Rodrigues]

On 12/05/2014 07:13 PM, Leland Smith wrote:

I found a not pretty solution to my problem on some discussion site.  It is the save command with the -text option.  It results in a single column of the data such that in EXCEL one has to move the individual data columns around appropriately.  Not pretty, but it's the only thing I've found.

Dear Leland

Can you restate your problem? You want to go from a 3d float matrix in Octave to Excel or to ascii? I don't understand how you have a single column by printing a matrix.

To Excel you can use the io package (xlswrite or the xlsopen oct2xls xlsclose combo, depending on the complexity of the problem).

To ascii there are several ways, depending on how you want the data to look like.

save('-ascii','filename','matrix') has the inconvenient property (from my point of view, of course) that all elements have the same format. Hence, if there are floats everything (including zeros) will appear with exponential notation.

dlmwrite('filename', matrix, '\t') will yield a matrix where the formats of different entries is personalized (hence 0 instead of 0.000000). In the formal specifier '\t' is tab, if you prefer space or comma write ' ' or ','.

I hope this helps.