How to extract year, month, day from character vectors?

2 visualizaciones (últimos 30 días)
Paul Barrette
Paul Barrette el 11 de Ag. de 2022
Comentada: Paul Barrette el 14 de Ag. de 2022
I have a character vector matrix (I think that's what it's called - it was obtained with cell2mat command applied to a *.csv file) which shows this when I open it (one column):
var =
'1970/01/01'
'1970/01/02'
'1970/01/03'
'1970/01/04'
'1970/01/05'
'1970/01/06'
I would like to produce a numerical matrix X with as many rows but three columns (year, month, day, respectively). I've explored numerous options, to no avail. Any suggestions?

Respuesta aceptada

Kevin Holly
Kevin Holly el 11 de Ag. de 2022
Editada: Kevin Holly el 11 de Ag. de 2022
var =['1970/01/01'
'1970/01/02'
'1970/01/03'
'1970/01/04'
'1970/01/05'
'1970/01/06']
var = 6×10 char array
'1970/01/01' '1970/01/02' '1970/01/03' '1970/01/04' '1970/01/05' '1970/01/06'
% I want to make you aware of Datetime arrays
datetime(var,'InputFormat','yyyy/MM/dd')
ans = 6×1 datetime array
01-Jan-1970 02-Jan-1970 03-Jan-1970 04-Jan-1970 05-Jan-1970 06-Jan-1970
% Here is how you can convert your data into a numerical matrix containing Year, Day, and Month columns
m = [];
for ii = 1:size(var,1)
m = [m;split(var(ii,:),"/")'];
end
X = str2double(m)
X = 6×3
1970 1 1 1970 1 2 1970 1 3 1970 1 4 1970 1 5 1970 1 6

Más respuestas (0)

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Productos


Versión

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by