Extract value until regexp case match

Question

0 个投票

Hi,

I have this string. I was hoping to use regexp in order to extract the time and date embedded in this string. I was going to use regexp '.*?<=216', as prior to 216 is all the values I was hoping to extract. I was hoping that there would be an easy way to extract the date and time to a separate cell array. Thanks for any and all help.

"9/12/2022 7:38:51 PM

216 Indicator"

2 个评论
显示无隐藏无

Rik 2022-9-23

While this could work, is there a reason why you can't match the date itself directly?

Dyel 2022-9-23

Is there a way using regexp to extract the datetime value, or something similar from a char array?

请先登录，再进行评论。

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

Follow Question

Answer 1

Stephen23 2022-9-23

在 MATLAB Online 中打开

1 个投票

Does the data you want to match always occur at the start of the string?

A = "9/12/2022 7:38:51 PM 216 Indicator";
B = regexp(A,'^\S+\s+\S+\s[AP]M','match','once')
B = "9/12/2022 7:38:51 PM"
T = datetime(B,'inputFormat','d/M/u h:m:s aa')
T = datetime
   09-Dec-2022 19:38:51

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Dyel 2022-9-26

在 MATLAB Online 中打开

This did the trick. Thanks Stephen.

How I did it was to split it up using the SplitString fuction, and then convert the string with the date to datetime, in case anyone may find it useful.

 for j = 1:length(cf)
        loopname = cf(j).name;
        filetext = fileread(loopname);
        txtStr = convertCharsToStrings(filetext);
        indVal{i,j} = cell2mat(regexp(filetext, '(?<=Indicator[^0-9]*)[+-]?[0-9]*\.?[0-9]+', 'match'));
        splitStr = regexp(txtStr,'\n','split');
        dateStr = splitStr{1};
        date = datetime(dateStr);
        dateVal{i,j} = date;
        
    end

请先登录，再进行评论。

Extract value until regexp case match

2 个评论
显示无隐藏无

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

类别

标签

Community Treasure Hunt

Extract value until regexp case match

2 个评论 显示 无 隐藏 无

采纳的回答

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

更多回答（0 个）

类别

标签

另请参阅

Community Treasure Hunt

2 个评论
显示无隐藏无

1 个评论
显示 -1更早的评论隐藏 -1更早的评论