Compare two Vectors and multiply equal entries

1 view (last 30 days)
Hi,
I got an orignal dataset with a set of IDs and a unique characteristic value for each ID. For example ID A has the characteristic value 1, ID B has 2 ID C has 3 and so on. I got a second array with entries like AABBCDDDEFFE and I want to create a resulting array that looks like 112234445665, how would you do that?
Thanks!

Accepted Answer

Stephen23
Stephen23 on 13 Oct 2021
ID = 'ABCDEF';
val = 1:6;
arr = 'AABBCDDDEFFE';
[X,Y] = ismember(arr,ID);
out = val(Y(X))
out = 1×12
1 1 2 2 3 4 4 4 5 6 6 5

More Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!