MATLAB time stamps reading

Any easy way to read all the co开发者_Python百科lumns in MATLAB?

my format is

date  time    y1   y2  y3   y4 .........................      
4/27/2010  00:3:09   34  45  45 56 ................     

so on... Currently i am reading these with the code:

[c,pathc]=uigetfile({'*.txt'},'Select the data','C:\Data');    
file=[pathc c];     
data= dlmread(file, ',', 1,3);    

so needless to say i am skipping the time stamps.

Was wondering if there is easy way to read the time stamps and plot my other columns against the time in hours.

my files are 43200 X 30 and some are 86400 X 90

Related question : is the format same for .csv and .xls files , i mean except of course xlsread

I already answered to your question on the same data here: skip reading headers in MATLAB

[c,pathc]=uigetfile({'*.txt'},'Select the data','C:\Data');
file=[pathc c];
A = importdata(file, ' ', 1);
dt = datenum(A.textdata(2:end,1),'mm/dd/yyyy');
tm = datenum(A.textdata(2:end,2),'HH:MM:SS');
tm = dt+tm-datenum('0:0','HH:MM'); %# combine date and time and correct for zero time.
data = A.data;

You can plot your data against tm and use DATETICK function to show date in any format.

plot(tm,data)
datetick('x','HH')
xlabel('Time, hours')

EDIT

You can also use Jonas's solution for previous question to read the data. Then do same as above:

dt = datenum(dateAndTimeCell(:,1),'mm/dd/yyyy');
tm = datenum(dateAndTimeCell(:,2),'HH:MM:SS');
tm = dt+tm-datenum('0:0','HH:MM');

plot(tm,dataArray,'o-')
datetick('x','HH')
xlabel('Time, hours')

I believe sscanf will do the trick for you.