How can I remove double quotes from a string?
42 views (last 30 days)
Show older comments
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?
0 Comments
Answers (2)
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
on 17 Jul 2020
[^""] is any one character that is not either " or " -- in other words it is the same [^"]
See Also
Categories
Find more on Whos 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!