Save .csv file as plain text

12 views (last 30 days)
Bernoulli Lizard
Bernoulli Lizard on 2 Oct 2012
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 Comments
Bernoulli Lizard
Bernoulli Lizard on 2 Oct 2012
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).

Sign in to comment.

Answers (1)

Daniel Shub
Daniel Shub on 2 Oct 2012
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 Comment
Bernoulli Lizard
Bernoulli Lizard on 2 Oct 2012
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.

Sign in to comment.

Categories

Find more on Data Import and Export in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!