MATLAB Answers

how do I import date from .xls where cell contains numbers and letters

조회 수: 6 (최근 30일)
Ryan Dillingham
Ryan Dillingham . 2013년 6월 4일
I am trying to import a .xls data file using [num, txt] = xlsread(filename);. I got the file to import giving me a number file and a text file. The text file includes the dates in format: [10-1-2005 0:05 MDT] all in one cell. I am trying to get the date and time into a datevector so that I can organize and graph the data in fractional years. Anyone know how I can extract the date and time and leave out the time zone?
Thanks in advance ryan

이 질문에 답변하려면 로그인하십시오.

채택된 답변

Leah
Leah 2013년 6월 4일
try strrep and replace with ''

추가 답변 (1개)

Azzi Abdelmalek
Azzi Abdelmalek 2013년 6월 4일
편집: Azzi Abdelmalek 님. 2013년 6월 4일
s={'10-1-2005 0:05 MDT';'11-1-2005 0:05 MDT'}
s=cellfun(@(x) datenum(strrep(x,'MDT','')),s)
dat=datestr(s,'dd-mm-yyyy HH:MM')

카테고리

Help Center 및 File Exchange에서 Time Series Objects에 대해 자세히 알아보기

태그

제품

Community Treasure Hunt

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

Start Hunting!

Translated by