Read date from .CSV in native format of yy-mm-dd

4 views (last 30 days)
Hello,
I am importing data from a .CSV where the native date format is yy-mm-dd. Using functions such as readcell or readmatrix return NaN or Matlab ends up looping because it is having issues with the date format. How can I import this? The formatting of the date is not important, I would just like to have some sort of date stamp for organizational purposes.
Many thanks in advance,
Thomas

Answers (1)

Stephen23
Stephen23 on 19 Jul 2022
As far as I can tell, it is not possible to specify the pivot year when calling READTABLE et al. But you can do it afterwards:
T = readtable('test.csv','Format','%s%f')
T = 2×2 table
timestamp data ____________ ______ {'22-07-19'} 3.1316 {'22-07-20'} 2.7183
T.timestamp = datetime(T.timestamp,'inputFormat','yy-MM-dd','PivotYear',2000)
T = 2×2 table
timestamp data ___________ ______ 19-Jul-2022 3.1316 20-Jul-2022 2.7183

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by