partial match of 2 string vectors with different lenghts

2 次查看（过去 30 天）
PH
PH 2018-6-6
评论： Rik 2018-6-7
Hi everyone,
I hope you can help me. I have two 2 string arrays (str1 and str2) with different lengths. For instance,
str1= ["16-10-2017 09:20:00"; "16-10-2017 09:21:00"; "16-10-2017 09:22:00"; "16-10-2017 09:23:00"] ]
str2= ["16-10-2017 09:21:00_water"; "16-10-2017 09:23:00_coffee"] ]
I would like to:
(1) match the first 19 characters of a str2 (in this case it is 16-10-2017 09:21:00) with str1
(2) create str3 that will give me a string array like this str3=[0;"16-10-2017 09:21:00_water";0;"16-10-2017 09:23:00_coffee"] So when there is an overlap use the value in str2 in str3, when there is no overlap use 0 or NAN.
Thanks,

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

回答（1 个）

Rik
Rik 2018-6-6
编辑：Rik 2018-6-6
Something like this:
str1= ["16-10-2017 09:20:00"; "16-10-2017 09:21:00"; "16-10-2017 09:22:00"; "16-10-2017 09:23:00"];
str2= ["16-10-2017 09:21:00_water"; "16-10-2017 09:23:00_coffee"];
temp=arrayfun(@extract_date,str2);
L=ismember(str1,temp);
str3=str1;
str3(~L)=0;
str3(L)=str2;
function date=extract_date(str)
str=char(str);
date=string(str(1:19));
end
  5 个评论
显示 3更早的评论
PH
PH 2018-6-7
Thanks, the code works with these strings. However, I tried the code with my original data and it did give me an error. str1's value is 6196x1 and str2's value is 14x1.
(In an assignment A(:) = B, the number of elements in A and B must be the same. Error in matching_code (line 5) str3(L)=str2;)
Rik
Rik 2018-6-7
Then the dates in str2 are non-unique. So which should be selected?

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by