Trouble using split function in matlab
조회 수: 6 (최근 30일)
이전 댓글 표시
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']
newdate = split(date, '/');
newdate(3) = reverse(newdate(3));
newdate = char(join(newdate, '/'))
%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,'/');
splitter(3) = reverse(splitter(3));
dates_new = char(join(splitter,'/'));
If you have a solution, please let me know! Thanks
댓글 수: 0
채택된 답변
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)
댓글 수: 2
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')
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Time Series Objects에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!