Grabbing numbers from a string

2015 6 23
1 个回答
回答已采纳
更新时间：2015 6 23
18 次查看（30 天）

0 个投票

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

0 个投票

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更早的评论 隐藏 3更早的评论

matlabuser12
matlabuser12 2015-6-23
This seems to work, but how do i convert teh cells to numbers?
Azzi Abdelmalek
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
matlabuser12 2015-6-23
I used your first set of code and got rid of the S's. so I have an array s full of cells of numbers that i cannot convert into a regular matrix.
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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by