필터 지우기
필터 지우기

Reading a time column

조회 수: 4 (최근 30일)
Shahar ben ezra
Shahar ben ezra 2021년 5월 2일
댓글: Star Strider 2021년 5월 2일
Hello
I have a CSV file, with columns of times
When I read the file by readmatrix or readcell or readtable
I get columns of values ​​rather than times
How can I fix the problem?

채택된 답변

Star Strider
Star Strider 2021년 5월 2일
Here is one approach —
Excel_Val = '16:50:13' % Original
Excel_Val = '16:50:13'
MATLAB_Val = rem(datenum(Excel_Val, 'HH:MM:SS'),1) % Fraction-Of-Day Representration
MATLAB_Val = 0.7015
dt = datetime(MATLAB_Val, 'ConvertFrom','datenum', 'Format','HH:mm:ss') % ‘datetime’ Conversion
dt = datetime
16:50:13
.
  댓글 수: 2
Shahar ben ezra
Shahar ben ezra 2021년 5월 2일
Thanks!
What is the 1 used for? (iin MATLAB_Val = rem(datenum(Excel_Val, 'HH:MM:SS'),1)
If I have a vector of times does it matter??
Star Strider
Star Strider 2021년 5월 2일
As always, my pleasure!
The 1 in the rem call isolates the decimal fraction part of the floating-point argument to it.
For example —
arg = pi
arg = 3.1416
decfrax_arg = rem(arg,1)
decfrax_arg = 0.1416
.

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Text Files에 대해 자세히 알아보기

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by