How can I remove double quotes from a string?

71 views (last 30 days)
Heidi Hirsh
Heidi Hirsh on 10 Dec 2018
Commented: Walter Roberson on 17 Jul 2020
I am reading in data from a .csv file using textread. The data looks like this:
"Date","Time","Temperature"
"2018-06-02","14:45:24","23.5942"
"2018-06-02","14:46:24","24.6013"
"2018-06-02","14:47:24","24.5911"
"2018-06-02","14:48:24","24.8547"
I can read in date, time, and temperature as strings but then I am left with the values in double quotes. Is there a way to read the values in some other way so I that I am left withouth the data in double quotes?

Answers (2)

Mark Thomson
Mark Thomson on 17 Jul 2020
Hi, I found readtable.m a bit slow.
You can also try this:
strs={'"Hi there"','"Joe"'} % Example cell array of strings with "..."
regexp(strs,'[^""]*','match','once')
I borrowed the regexp syntax from:
https://de.mathworks.com/matlabcentral/answers/399532-recovering-text-between-parentheses-using-regexp#answer_319061
  1 Comment
Walter Roberson
Walter Roberson on 17 Jul 2020
[^""] is any one character that is not either " or " -- in other words it is the same [^"]

Sign in to comment.


Community Treasure Hunt

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

Start Hunting!