How do I find and replace strings in a cell array with numerical values?

Question

Brad 2017-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/328014-how-do-i-find-and-replace-strings-in-a-cell-array-with-numerical-values

评论： Brad 2017-3-4

I've got the following 3 x 5 cell array;

1110000000  20000.9000000000  100.450000000000  22445  'SET_THRESH'
2220000000  20000.9000000000  200.670000000000  22445  'HOLD_THRESH'
3330000000  20004.6000000000  300.890000000000  22445  'DELETE_THRESH'

I'm trying to come up with a technique where the strings in column 5 are automatically replaced with their numerical equivalents (SET_THRESH is 0, HOLD_THRESH is 2, DELETE_THRESH is 3). The resulting 3 x 5 cell array would look like this;

1110000000  20000.9000000000  100.450000000000  22445  '0'
2220000000  20000.9000000000  200.670000000000  22445  '2'
3330000000  20004.6000000000  300.890000000000  22445  '3'

Is it possible to achieve the desired output using a combination of functions within a loop?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-3-4

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/328014-how-do-i-find-and-replace-strings-in-a-cell-array-with-numerical-values#answer_257231

在 MATLAB Online 中打开

possible_threshes = {'SET_THRESH', 'HOLD_THRESH', 'DELETE_THRESH'};
thresh_vals = [0, 2, 3]
[tf, idx] = ismember(YourCell(:,5), possible_threshes);
YourCell(tf, 5) = num2cell( thresh_vals( idx(tf) ) );

Any entry that is unmatched will be left as a string.