Trouble using split function in matlab

13 次查看(过去 30 天)
此 个问题 已被 Cris LaPierre 标记
Having some trouble w/ my data.
The dates are showing up wrong. For example:
3/9/9102
3/10/9102
Obviously, i didn't collect data in 9102 and if you read it backwards, its 2019 which would be the correct date.
Does anyone know how to correct for this?
For example, how would you convert
3/9/9102 --> 3/9/2019
If someone knows, let me know. Thanks
Someone helped me and gave me this code but unfortunately, it doesn't work for multiple dates in a column. It does work for one date though to reverse the year to 2019, it just doesn't work for multiple dates
%For just a single date, it works.
date = ['3/11/9102']
date = '3/11/9102'
newdate = split(date, '/');
newdate(3) = reverse(newdate(3));
newdate = char(join(newdate, '/'))
newdate = '3/11/2019'
%For multiple dates in a column, it doesn't work.
dates = ['3/11/9102'; '3/12/9102'; '3/13/9102'; '3/14/9102'; '3/15/9102';];
splitter = split(dates,'/');
Error using split
First argument must be text.
splitter(3) = reverse(splitter(3));
dates_new = char(join(splitter,'/'));
If you have a solution, please let me know! Thanks

采纳的回答

Akira Agata
Akira Agata 2022-7-22
How about the following?
% Example
dates = {'3/11/9102'; '3/12/9102'; '3/13/9102'; '3/14/9102'; '3/15/9102'};
% Split by '/', apply fliplr function to '9102' and concatenate
c = split(dates, '/');
c(:, 3) = cellfun(@fliplr, c(:,3), 'UniformOutput', false);
datesNew = join(c, '/');
% Show the result
disp(datesNew)
{'3/11/2019'} {'3/12/2019'} {'3/13/2019'} {'3/14/2019'} {'3/15/2019'}
  2 个评论
Walter Roberson
Walter Roberson 2022-7-22
dates = {'3/11/9102'; '3/12/9102'; '3/13/9102'; '3/14/9102'; '3/15/9102'};
datesNew = regexprep(dates, '(\d)(\d)(\d)(\d)$', '$4$3$2$1')
datesNew = 5×1 cell array
{'3/11/2019'} {'3/12/2019'} {'3/13/2019'} {'3/14/2019'} {'3/15/2019'}
BA
BA 2022-7-22
Both work great, thanks a lot guys!

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by