How to extract numbers in a string?

Question

Ali Almakhmari 2021-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1588514-how-to-extract-numbers-in-a-string

回答： Image Analyst 2021-11-17

So I have a huge table (672 elements) and each cell has a string that involves a number and some letters at the end with a variable space between them, but I want to remove the letters and convert the string number to an actual number. For example:

cell 1: "1.32e8 Cis"

cell 2: "8.47e-2 tOE"

cell 3: "4.55e8 pov"

And so on....for 672 cells.

What I want is to convert this to

1.32e8

8.47e-2

4.55e8

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2021-11-17

Please be clear.

Is your data is in a table variable, or a cell array variable?

There might be different ways to do it depending on what type of variable it is. Can you attach it in a .mat file?

请先登录，再进行评论。

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

Answer 1

Image Analyst 2021-11-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1588514-how-to-extract-numbers-in-a-string#answer_833269

在 MATLAB Online 中打开

For a cell array, try this:

ca = {"1.32e8         Cis"
    "8.47e-2                                                                         tOE"
    "4.55e8                          pov"}
ca = 3×1 cell array
    {["1.32e8         Cis"                                                                 ]}
    {["8.47e-2                                                                         tOE"]}
    {["4.55e8                          pov"                                                ]}
for k = 1 : numel(ca)
    ca{k} = sscanf(ca{k}, '%f');
end
ca % Show again in the command window
ca = 3×1 cell array
    {[132000000]}
    {[   0.0847]}
    {[455000000]}