extracting dates within a text

9 次查看（过去 30 天）
Sadegh Nabavi
Sadegh Nabavi 2019-11-30
评论： Sadegh Nabavi 2019-11-30
Good day all,
I have a csv file with texts and and dates mixed in each cell. I need to extract the dates that follow a specific text and store them in cell arrays. Example: "MovExperiment/MovingBarParameters started at 2018-04-17_09-32-11"; please see highlighted cells in the attached image.
What is the efficient way to do this?
Thanks,
Sadegh
  1 个评论
dpb
dpb 2019-11-30
Dunno and can't experiment without a copy of the significant portion of the file to look at.
Attach a (smallish) section of the file, not an image.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

dpb
dpb 2019-11-30
编辑：dpb 2019-11-30
matchstr='LoomingExp'; % string to match
c=textread('book1.csv','%s','delimiter',''); % read as cellstr array
c=char(c(contains(c,matchstr))); % save those with matching string/convert to char array
dt=datetime(c(:,end-18:end),'InputFormat','yyyy-MM-dd_HH-mm-ss'); % convert date strings to datetime
textread has been deprecated by TMW, but it's still useful in being able to do many things without the bother of having to have a file handle but using the filename directly.
  3 个评论
显示 1更早的评论
dpb
dpb 2019-11-30
Oh. I had done char() to convert to character array at command line but missed it when cut and pasted...
c=char(c(contains(c,'LoomingExp')));
Updated Answer
Sadegh Nabavi
Sadegh Nabavi 2019-11-30
Thanks a lot. It works smoothly.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Identification 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by