find in structure a certain string

Question

Leonardo Wayne 2016-4-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/279144-find-in-structure-a-certain-string

评论： Leonardo Wayne 2016-4-18

raw is a cell.

I would like to find the identification number in the example which is 13161509800019, but I only want the cell that contains 1-2-3, as the cell below it contains a trailing 4-5-6. Also how can I do that for any number of identification numbers containing 1-2-3 column 1 excluding first row 'SERIAL'?

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

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2016-4-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/279144-find-in-structure-a-certain-string#answer_218013

编辑：Azzi Abdelmalek 2016-4-15

在 MATLAB Online 中打开

C={'serial';'123456 1-2-3';'1452145 4-5-6';'745841 3-2-4';'85471245 1-2-3'}
C=C(2:end);
idx=~cellfun(@isempty,regexp(C,'1-2-3'))
D=C(idx)
out=regexp(D,'.+(?=1-2-3)','match')
out=str2double([out{:}])

2 个评论
显示无隐藏无

Leonardo Wayne 2016-4-18

Hi Azzi, thanks for the answer. I am stuck with another issue. If you take a look the images 1-4. The cell "get_motors_no_workbook2_NO_123" being created in image 1 has two index numbers when I click on the cell values and reach the image 4. How can that be, does this mean that this is a cell inside another cell?

Also, if I want "get_motors_no_workbook2_NO_123" to have only 6x1 cell and those individual rows in image 2 to be char values as shown in 4 not 1x1 cell as is shown in 3.

In other words: e.g. refer to image 2: I want row 1 which is '13161509800019' to be a char and not a 1x1 cell and so on. Image 1 has the code!

<<

>>

Leonardo Wayne 2016-4-18