MATLAB: Merge two column in the table

datetabletime

Dear all, I have text file like this (attached file): 
Date                       SR
2020/02/24 00:00:00.000  3.457785
2020/02/24 00:00:01.000  3.457785
2020/02/24 00:00:02.000  3.457785
2020/02/24 00:00:03.000  3.457785
I wanna convert it to table like this:
       Date                  SR
2020/02/24 00:00:00.000  3.457785
2020/02/24 00:00:01.000  3.457785
2020/02/24 00:00:02.000  3.457785
2020/02/24 00:00:03.000  3.457785
But when I use the readtable. I got this result:
m=readtable('test.txt')
m =
4×3 table
Var1 Var2 Var3
______________ ________ ______
{'2020/02/24'} 00:00:00 3.4578
{'2020/02/24'} 00:00:01 3.4578
{'2020/02/24'} 00:00:02 3.4578
{'2020/02/24'} 00:00:03 3.4578
It spilit the column Date into 2 columns. Please give me the idea to fix this. Thanks so much.

Best Answer

One approach: 
T1 = readtable('test.txt');
T1.Var1 = datetime(T1.Var1, 'InputFormat','yyyy/MM/dd');
T1.Var1 = T1.Var1 + T1.Var2;
T1.Var2 = [];
producing: 
T1 =
  4×2 table
            Var1             Var3 
    ____________________    ______
    24-Feb-2020 00:00:00    3.4578
    24-Feb-2020 00:00:01    3.4578
    24-Feb-2020 00:00:02    3.4578
    24-Feb-2020 00:00:03    3.4578
Related Question