obtain numbers from mixed cells
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Irem Velibeyoglu
el 7 de Mayo de 2016
Comentada: Irem Velibeyoglu
el 7 de Mayo de 2016
I'm trying to import data from excel using xlsread command. In the original data, I have humidity values which are represented as for example "81 %". Matlab does not see this expression when I use
data = xlsread('filename.xlsx')
command. Then I tried
[num,str] = xlsread('filename.xlsx').
Now, num is an empty matrix and str is a vector of cells containing values such as 81 % in each cell.
I only want to obtain the value either as 0.81 or 81, it does not matter which I can obtain.
Can you help me obtain only the numbers from this vector of cells? Thanks!
0 comentarios
Respuesta aceptada
Azzi Abdelmalek
el 7 de Mayo de 2016
Editada: Azzi Abdelmalek
el 7 de Mayo de 2016
[num,str] = xlsread('fic.xlsx')
out=regexp(str,'[\d\.]+','match')
out=cellfun(@(x) str2double(x{:}),out)
Más respuestas (0)
Ver también
Categorías
Más información sobre Characters and Strings 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!