How to extract info from a cell array using strsplit

5 views (last 30 days)
ep = {'ELTOK' , 'HMR' , 'NILUG' , 'XILAN'}
How can I use strsplit to extract above words from the first column (cell array) of a table and how to get the count of each word (how many times each word was meantiond in that colounm).
example: I need to exclude all but these specific words 'ELTOK' , 'HMR' , 'NILUG' , 'XILAN' and i want to know the count of each of these words after exctracting.
  5 Comments
Walter Roberson
Walter Roberson on 30 Sep 2020
If my answer did not work for you, then please indicate what difficulty you encountered.

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 30 Sep 2020
targets = {'ELTOK' , 'HMR' , 'NILUG' , 'XILAN'}.';
temp = regexp(text1, '_', 'split');
temp = vertcat(temp{:});
[~, idx] = ismember(temp, targets);
counts = accumarray(idx(:)+1, 1); %words not in list will have idx 0
counts = reshape(counts(2:end),[],1); %first entry counted other words
results = table(targets, counts);

Categories

Find more on MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!