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

조회 수: 1 (최근 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에서 Word games에 대해 자세히 알아보기

태그

제품

Community Treasure Hunt

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

Start Hunting!

Translated by