How to load CSV file with space?
4 views (last 30 days)
Show older comments
I have a csv file that loads very perfectly from 2nd column onwards.
data = csvread('filename.csv',1,1);
However, in the first column of my data I have date:
the format of the date is
2012/09/15 00:00:00,0,-13.654,...
2012/09/15 00:00:01,0,-18.654,...
2012/09/15 00:00:02,0,-166.654,...
2012/09/15 00:00:03,0,-178.654,...
...
...
...
Here, date is space separated with time. This creates error in loading the file using
data = csvread('filename.csv',1,0);
Can anyone suggest what to do?
0 Comments
Accepted Answer
madhan ravi
on 2 Nov 2018
Edited: madhan ravi
on 2 Nov 2018
What happens when you use
readtable()
because they are capable of reading dates by default
11 Comments
madhan ravi
on 2 Nov 2018
Anytime :) ,if it worked make sure to accept the answer so that people know the question is solved
More Answers (0)
See Also
Categories
Find more on Text Files 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!