Grabbing numbers from a string
显示 更早的评论
I have a data set where some numbers are numbers like (124,456, 987) and others are numbers with an letter on them like (123P,232P) so when i read in [Data,Text] = xlsread(...) half my data set goes to data and the other half to text. The data variable puts NaN where the 124P type data was, how can I extract the number off the P and put it where the NaNs are?
2 个评论
per isakson
2015-6-23
编辑：per isakson
2015-6-23
As a start, replace
[Data,Text] = xlsread(...)
by
[~,~,raw] = xlsread(___)
that makes it easier to keep track of the "cell" positions.
Then upload a sample of raw.
If the data is in a text file, it might be a good idea to bypass Excel.
matlabuser12
2015-6-23
编辑：matlabuser12
2015-6-23
采纳的回答
Azzi Abdelmalek
2015-6-23
编辑：Azzi Abdelmalek
2015-6-23
s={115;118;118;'121';118;'126P';132}
idx=cellfun(@isstr,s)
b=s(idx)
c=regexp(b,'\d+(\.\d+)?','match')
d=cellfun(@str2double,c,'un',0)
s(idx)=d
Or
s={115;118;118;'121';118;'126P';132}
out=cellfun(@(x) str2double(regexp(num2str(x),'\d+(\.\d+)?','match')),s)
5 个评论
matlabuser12
2015-6-23
Azzi Abdelmalek
2015-6-23
编辑：Azzi Abdelmalek
2015-6-23
with the second method, they are already double
s={115;118;118;'121';118;'126P';132}
out=cellfun(@(x) str2double(regexp(num2str(x),'\d+(\.\d+)?','match')),s)
matlabuser12
2015-6-23
Azzi Abdelmalek
2015-6-23
If you use the first code,add
out=str2double(out)
matlabuser12
2015-6-23
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
