How do I get the date out of a filename using regexp?
30 次查看(过去 30 天)
显示 更早的评论
Currently, I have a list of files that are saved as the following 'xxx_2014_06_03_00_00_01'. I'd like to extract the date in the file name using regexp. Currently, my code is:
fdate=regexp(fList(i).name,'_/d+','once')
dt=datetime(fdate,'InputFormat','dd-MM-yyyy HH:mm:ss')
However, whenever I test it out, fdate is always returned as empty. I'm extremely confused about regexp and how to use it.
Thanks!
0 个评论
采纳的回答
Star Strider
2019-11-21
There are likely several ways to approach this. I would do it a bit differently:
str = 'xxx_2014_06_03_00_00_01';
fdate = regexp(str, '\d*','match');
datev = str2double(fdate);
dt=datetime(datev)
producing (here):
dt =
datetime
03-Jun-2014 00:00:01
I left these as separate lines to demonstrate how it works. The str2double call could be inserted into the datetime call.
0 个评论
更多回答(2 个)
Jeremy
2019-11-21
编辑:Jeremy
2019-11-21
str = 'xxx_2014_06_03_00_00_01';
id = regexp(str,'\d')
Returns:
id =
5 6 7 8 10 11 13 14 16 17 19 20 22 23
These are the indices of str that contain numeric digits. If you know that the 'xxx' part of the filename will not contain numeric digits, then you could then go ahead and say
year = str2double(str(id(1:4)));
month = str2double(str(id(5:6)));
etc.
Alternatively, you could use 'strtok' and pass it the underscore character as a delimiter to get a string of the datetime and convert those to integers. This is likely less efficient, though.
0 个评论
Stephen23
2019-11-21
In one line without intermediate indices or double vector:
>> str = 'xxx_2014_06_03_00_00_01';
>> dtm = datetime(regexp(str,'(\d+_?){6}','match','once'),'InputFormat','yyyy_MM_dd_HH_mm_ss')
dtm =
03-Jun-2014 00:00:01
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!