RE: Converting a Column of Data into ASCII Rows

[Leland Smith]

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

Ben