obtain numbers from mixed cells

1 次查看（过去 30 天）
Irem Velibeyoglu
Irem Velibeyoglu 2016-5-7
评论： Irem Velibeyoglu 2016-5-7
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!

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2016-5-7
编辑：Azzi Abdelmalek 2016-5-7
[num,str] = xlsread('fic.xlsx')
out=regexp(str,'[\d\.]+','match')
out=cellfun(@(x) str2double(x{:}),out)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by