Extracting a specific number from an excel cell

5 ビュー (過去 30 日間)
doublebi
doublebi 2019 年 6 月 6 日
コメント済み: doublebi 2019 年 6 月 7 日
Hi all!
I'm new on MATLAB and I have to extrapolate a specific data from a cell in an excel sheet, to assign it a name and put it in a new array. The problem is that I don't need all the values in the cell, but only the last one, as in the picture.
Cattura.PNG
How can I do it?
Thank you!

採用された回答

Akira Agata
Akira Agata 2019 年 6 月 6 日
How about the following?
[~,~,C] = xlsread('yourExcel.xlsx');
C = extractBetween(C,'(',')');
C = extractAfter(C,' ');
data = str2double(C);
  1 件のコメント
doublebi
doublebi 2019 年 6 月 7 日
Thank you, it works! :)

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

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by