How to load CSV file with space?

5 次查看（过去 30 天）

Megha 2018-11-2

评论： madhan ravi 2018-11-2

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?

madhan ravi 2018-11-2

编辑：madhan ravi 2018-11-2

What happens when you use

readtable()

because they are capable of reading dates by default

Megha 2018-11-2

Yes, Thank you

madhan ravi 2018-11-2

Anytime :) ,if it worked make sure to accept the answer so that people know the question is solved

MATLAB Programming Files and Folders File Operations

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

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

Translated by