find in structure a certain string

3 ビュー (過去 30 日間)
Leonardo Wayne
Leonardo Wayne 2016 年 4 月 15 日
コメント済み: 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'?

採用された回答

Azzi Abdelmalek
Azzi Abdelmalek 2016 年 4 月 15 日
編集済み: Azzi Abdelmalek 2016 年 4 月 15 日
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
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
Leonardo Wayne 2016 年 4 月 18 日
never mind. I have solved it.

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeFeature Detection and Extraction についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by