insert date in date .txt

Hi, I have a series of data that is arranged per month for 5 years (01/2001 - 12/2005)
I would like the first column of my data to be the date written as follows:
200101
200102
200103
.
.
.
200512

Answers (1)

KALYAN ACHARJYA
KALYAN ACHARJYA on 21 Oct 2019
Edited: KALYAN ACHARJYA on 21 Oct 2019
One way, save all file as cell array elements as strings
data_file={'01/2001','02/2001','03/2001','12/2005'}; % Just an example
result=zeros(1,length(data_file));
for i=1:length(data_file)
data=sscanf(data_file{i},'%d/%d'); % This trick from @Walter Sir
data=strcat(num2str(data(2)),num2str(data(1)));
result(i)=str2double(data);
end
result'
There may be more easier solution
Result:
ans =
20011
20012
20013
200512

Categories

Tags

Asked:

on 21 Oct 2019

Edited:

on 21 Oct 2019

Community Treasure Hunt

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

Start Hunting!