Seperate Matlab data for my text file

I have data where the year and month are stuck together, as seen 180001, should be 01 1800, how do I seperate that?

Answers (1)

Bhaskar R
Bhaskar R on 20 Jan 2020
Edited: Bhaskar R on 20 Jan 2020
Suppose your data in the variable data
data_in_time = datetime(num2str(data(:,1)), 'Format', 'yyyyMM');
data_in_time.Format = 'MM-yyyy';
If you want data in double class instead of datetime
data_in_double = datevec(data_in_time);
% then get the repective column accordingly(years/months)

1 Comment

Stephen23
Stephen23 on 20 Jan 2020
Edited: Stephen23 on 20 Jan 2020
Setting the 'Format' option is definitely the way to go, although note that like textscan it should specify how to handle each column in the file. See the documentation examples:

This question is closed.

Products

Asked:

on 20 Jan 2020

Closed:

on 20 Aug 2021

Community Treasure Hunt

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

Start Hunting!