Filtering a table containing Hex data

Question

Matt 2017-6-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342986-filtering-a-table-containing-hex-data

评论： Jan 2017-6-2

Hi,

I currently have a table (data) containing many different data types however, I am trying to access the rows containing a certain Hex value in a column. Below is everything I have tried so far:

data=
Entry No | Time        | Word
---------|-------------|-------
1        | 000:123:456 | 0123  
2        | 000:123:457 | A0A0
3        | 000:123:543 | F0F0
4        | 000:124:123 | FFA0
5        | 000:124:987 | 2A0F
Msg = find(strcmp('F0F0', data.Col));
Msg = find(ismember(data.Col,'F0F0')); 
Msg = strfind(data.Col, 'F0F0');
Msg = data(data{:, 20} == F0F0,:);

Due to the different datatypes in other columns I also cannot convert the table to an array. If you have any suggestions on how I can do this, that would be great

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

请先登录，再进行评论。

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

Answer 1

Jan 2017-6-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342986-filtering-a-table-containing-hex-data#answer_269329

编辑：Jan 2017-6-2

在 MATLAB Online 中打开

Perhaps:

Msg = data(strcmp(data{:, 20}, 'F0F0'), :);

If you post the input data, we could test the suggestions.

2 个评论
显示无隐藏无

Matt 2017-6-2

Hi Jan,

Thanks for your answer but this gives me a blank table. I have 51 columns in my dataset (obviously the above is just an example) so 'Msg' is a 0x51 table.

Jan 2017-6-2

@Matt: Please post a samll example of your data, as Matlab code or MAT file. I do not have any idea, where the "20" comes from in your code, so my suggestion is based on pure guessing yet. Give me (and all readers) a chance to solve your problem by posting your data.

请先登录，再进行评论。