How to extract numbers in a string?

3 views (last 30 days)
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 Comment
Image Analyst
Image Analyst on 17 Nov 2021
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?

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 17 Nov 2021
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]}

More Answers (0)

Categories

Find more on Characters and Strings in Help Center and File Exchange

Tags

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by