Grabbing numbers from a string

1 次查看（过去 30 天）
matlabuser12
matlabuser12 2015-6-23
评论： matlabuser12 2015-6-23
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
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
matlabuser12 2015-6-23
编辑：matlabuser12 2015-6-23
It is an .xls file unfortunately. This is a snippet from the data column:
115
118
118
121
118
'126P'
132

请先登录，再进行评论。

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

采纳的回答

Azzi Abdelmalek
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 个评论
显示 3更早的评论
Azzi Abdelmalek
Azzi Abdelmalek 2015-6-23
If you use the first code,add
out=str2double(out)
matlabuser12
matlabuser12 2015-6-23
Got it to work with cel2mat following removal of the letter character. thank you

请先登录，再进行评论。

更多回答（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