[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Converting a Column of Data into ASCII Rows

From: Leland Smith
Subject: RE: Converting a Column of Data into ASCII Rows
Date: Wed, 3 Dec 2014 17:17:14 -0800

That didn't work because I needed a separator so I could read it into EXCEL.  csvwrite did the trick.

Subject: Re: Converting a Column of Data into ASCII Rows
From: address@hidden
Date: Sun, 30 Nov 2014 20:15:59 -0500
CC: address@hidden
To: address@hidden

On Nov 30, 2014, at 8:08 PM, Leland Smith <address@hidden> wrote:

I need to write rows of data to an ascii file for later EXCEL conversion.  this worked fine when my test script source data was originally a row.  I converted it to ascii with num2str, and the resulting file was EXCEL compatible. The data I really need to write is in a column (1522x1).  When I transpose it and then num2str it there are no spaces between the numbers, and Excel won't read it.  Even if I don't transpose it, and the num2str result looks right, EXCEL wont take it.  How can I get spaces between the numbers, or get something that excel will read? Actually the row string data is pretty worthless for anything.  
I considered sprint, but there were no format types for adding spaces as far as I could tell.

No need for num2str. Just try …

save -ascii filename.txt variablename


reply via email to

[Prev in Thread] Current Thread [Next in Thread]