How to open .CSV file ?

I want to open CSV file. (please find the attachment)

in the CSV file, I have date and time in the different column but I want to combine in one column. I have read with following code but I getting an error.

fbc = fopen('ABCD.CSV');

BC = textscan(fbc, '"%.f-%3.s-%.f", "%.f:%.f", %.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f');

fclose(fbc);

Answer 1

[KSSV]

[num,txt,raw] = xlsread('ABCD.csv') ;

[Vishnu Dhakad]

Thank you, sir

but time is showing in decimal, how to correct into normal?

I want to use the function fopen and textscan.

Can you explain to me how to use this type of function?

Answer 2

[Walter Roberson]

fmt = ['%{dd-MMM-yy}D%{HH:mm}D', repmat('%f', 1, 50)];
fbc = fopen('ABCD.CSV', 'r', 'n', 'UTF8');
BC = textscan(fbc, fmt, 'Delimiter', ',', 'CollectOutput', 1);
fclose(fbc);
dt = BC{1}+(BC{2}-dateshift(BC{2},'start','day'));
dt.Format = 'default';
numbers = BC{3};