How to format csv file to columns?

2 次查看（过去 30 天）
Comgan
Comgan 2017-11-13
评论： Comgan 2017-11-13
I'm creating a csv-file containing data in over 400k rows and 4 columns via dlmwrite. First row is the header but that shouldn't really matter. My problem is, all the columns are written comma-separated. But I need them to be in the specific columns to have a better overview in Excel. I tried different stuff, didn't really work. Basically I need to execute the "text to columns"-command from Excel by using Matlab. I found the Syntax
TextToColumns( Destination , DataType , TextQualifier , ConsecutiveDelimiter , Tab , Semicolon , Comma , Space , Other , OtherChar , FieldInfo , DecimalSeparator , ThousandsSeparator , TrailingMinusNumbers )
for the actxserver, but since I'm quite new to Matlab, I don't really now how to transfer it to Matlabcode. If there is an easier way, I'd appreciate that as well.
  2 个评论
Stephen23
Stephen23 2017-11-13
编辑：Stephen23 2017-11-13
"My problem is, all the columns are written comma-separated. But I need them to be in the specific columns to have a better overview in Excel."
That makes no sense: Excel has no problem opening CSV or TSV files, and allow you to specify the separator character when opening a file, so a well formatted CSV file should be no problem at all.
"I tried different stuff, didn't really work"
What does "didn't really work" actually mean? What did you do that did not "work"? What are you actually trying to achieve? What is your OS locale setting?
Comgan
Comgan 2017-11-13
Of course I can open the csv file with excel, but all data is written comma-separated in the first column and I need it to be in the actual column like the 3rd value of the row has to be in the C-column.
I'm reading in some data, sorting out, calculating and forming a new matrix. Now I want to safe this new matrix as a file easy to open and see which value belongs to wich row and column. To specify the columns I created an other matrix with the headers. So both matrixes go in one file, sorted and all.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by