Save .csv file as plain text

2012 10 2
1 个回答
9 次查看（30 天）

0 个投票

Currently I am saving data to a .csv file, opening that file, and extracting certain columns. However, the only way that Matlab will read more than the first row is to open the saved csv file in Word and save. Words default is to convert it to plain text when saved (still a csv file, though)- so when I do this, Matlab has no trouble reading the entire file.
So, is there anyway that I can make Matlab save it as plaintext in the first place, to avoid opening and saving each file in Word?
My format is comma delimited, with carriage returns for each row. The Word-saved file and the original look identical when opened in notepad, but Matlab thinks there is a difference.
Thanks

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Thomas
Thomas 2012-10-2
What command do you use to read the csv file in MATLAB?
Bernoulli Lizard
Bernoulli Lizard 2012-10-2
[C1 C2] = csvimport(fileName,'columns', [2, 8] ,'noHeader', true);
Daniel Shub
Daniel Shub 2012-10-2
Where are the csv files coming from originally?
Bernoulli Lizard
Bernoulli Lizard 2012-10-2
I opened a .txt file, changed it from semicolon delimited to comma delimited, and then wrote it to a csv file myself. I realize it's not the most efficient method, but I need it to be a csv file in the end, and writing to a .csv file lets me extract only the columns that I want (couldn't figure out how to do this with just a one column string from a .txt file).

请先登录，再进行评论。

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

回答（1 个）

Daniel Shub
Daniel Shub 2012-10-2

0 个投票

The question seems a little weird to me. I think of csv files are being plain text files. I also do not see the difference between a semicolon delimited file and a comma delimited file. Finally, in R2011a I don't have a command csvimport, but there is csvread and dlmread. I would suggest using dlmread on the semicolon delimited file and then use MATLAB to extract the columns you want.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Bernoulli Lizard
Bernoulli Lizard 2012-10-2
I thought csv files were plain text too, but for some reason saving it in Word makes it work. Word gave me a warning that saving it as plain text might cause troubles, so I assumed that it was converting the format somehow.
csvread doesn't seem to allow me to extract only certain columns, but csvimport does.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Standard File Formats 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by