How to load CSV file with space?

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?

Answer 1

[madhan ravi]

What happens when you use

readtable()

because they are capable of reading dates by default

[Megha]

readtable('filename.csv')

it creates error

Error using readtable (line 198) Unable to open file

[madhan ravi]

filename.csv should be the name of your csv file

[Megha]

Yes, ofcourse. This is an example for showing some filename

[madhan ravi]

upload your file then

[madhan ravi]

>> readtable('sample.txt')

ans =

    4×3 table

              Var1             Var2     Var3  
      _____________________    ____    _______

      '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.65
      '2012/09/15 00:00:03'     0      -178.65

[Megha]

Hey, thank you for your efforts. But, please note that the data file is not text file. It is csv file.

So readtable asks for text format.

When I tried with text file, It works well like you have shown in above example

[Megha]

Hey, Thank you very much for your time and efforts.

I found the solution.

opts = detectImportOptions('filename.csv');

T = readtable('filename.csv',opts);

Thanks!

[Walter Roberson]

Csv files are defined as text files. If you were to rename that sample.txt to sample.csv it would be able to read it.

[madhan ravi]

@Megha exactly as sir Walter mentions if you change .txt to .csv it would read the file without any flaw!

[Megha]

Yes, Thank you

[madhan ravi]

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