Common substring index from two string arrays

9 visualizzazioni (ultimi 30 giorni)
I have two string arrays a and b and I need to find the index matching the substring numbers (within string arrays). For example, in a string array a, 01, 02, 03 are the substrings matching in string array b.
a = {'frame01', 'frame02', 'frame03'};
a = string(a);
b = {'capture00.jpg' 'capture01.jpg', 'capture02.jpg', 'capture03.jpg', 'capture04.jpg'};
b = string(b)
Desired output index of string array b should be:
Index_b = [2 3 4]
Desired output index of string array a should be:
Index_a = [1 2 3]
Without for-loop solution is preferred.
Any help is appreciated!
  4 Commenti
Stephen23
Stephen23 il 2 Nov 2021
Do the substring numbers require the same leading zeros or just the same numeric value, i.e. is '3' the same as '03' ?
Preetham Manjunatha
Preetham Manjunatha il 2 Nov 2021
It is numbers with leading zeros in this example. But in general can be without leading zeros.

Accedi per commentare.

Risposta accettata

Stephen23
Stephen23 il 2 Nov 2021
a = ["frame01", "frame02", "frame03"];
b = ["capture00.jpg", "capture01.jpg", "capture02.jpg", "capture03.jpg", "capture04.jpg"];
[~,ia,ib] = intersect(regexp(a,'\d+','once','match'),regexp(b,'\d+','once','match'))
ia = 3×1
1 2 3
ib = 3×1
2 3 4
  2 Commenti
Stephen23
Stephen23 il 2 Nov 2021
And if you want to compare numeric values (i.e. disregard the leading zeros) then:
a = ["frame01", "frame02", "frame03"];
b = ["capture00.jpg", "capture01.jpg", "capture02.jpg", "capture03.jpg", "capture04.jpg"];
[~,ia,ib] = intersect(...
str2double(regexp(a,'\d+','once','match')),...
str2double(regexp(b,'\d+','once','match')))
ia = 3×1
1 2 3
ib = 3×1
2 3 4

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Characters and Strings in Help Center e File Exchange

Prodotti


Release

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by