Extract Numbers from a String

2 次查看（过去 30 天）
Matthew Brandsema
Matthew Brandsema 2014-11-23
编辑： Matthew Brandsema 2014-11-23
I have the following string from an excel file.
f 27//1 29//2 5//3 2//4
I want to extract the first number before each // sign. So for example, in this case, I need to extract the numbers 27 29 5 2
I am looking up how to do but but cannot seem to find a straightforward way, would anyone be able to clear things up for me? Thanks!

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2014-11-23
a='f 27//1 29//2 5//3 2//4'
b=str2double(regexp(a,'\S+(?=//)','match'))
  2 个评论
Matthew Brandsema
Matthew Brandsema 2014-11-23
Thanks a lot! This is exactly what I need!
Matthew Brandsema
Matthew Brandsema 2014-11-23
编辑：Matthew Brandsema 2014-11-23
Okay I realized upon importing the xls file, I actually get the form
'27//1'
for the cells in question. I am messing around with regexp but I simply do not have enough experience with it to know what I am doing. How would I extract the first number in cells that look like that? I tried using the same type of thing but it isn't working.
The furthest I got was get '27' But the ' symbols are messing up the str2num function.

请先登录，再进行评论。

更多回答（1 个）

the cyclist
the cyclist 2014-11-23
编辑：the cyclist 2014-11-23
You want the regexp command. For example,
s = 'f 27//1 29//2 5//3 2//4'
regexp(s,'//')
ans =
5 11 16 21
finds the positions of the //.
You could similarly find the positions of the spaces, and the numbers you want are between them.
You may then need to use str2num (or similar command) to convert the strings to numeric variables.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by