Extracting a specific number from an excel cell

5 visualizaciones (últimos 30 días)
doublebi
doublebi el 6 de Jun. de 2019
Comentada: doublebi el 7 de Jun. de 2019
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!

Respuesta aceptada

Akira Agata
Akira Agata el 6 de Jun. de 2019
How about the following?
[~,~,C] = xlsread('yourExcel.xlsx');
C = extractBetween(C,'(',')');
C = extractAfter(C,' ');
data = str2double(C);

Más respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by