How to keep only numbers in a cell (.xlsx file)?

7 次查看（过去 30 天）
Ivan Mich
Ivan Mich 2021-2-7
编辑： Ive J 2021-2-7
I have an .xlsx file. In one column there are numbers and text in each cell (e.g. 0.562550 (AHV)).
How could I keep ONLY the number of each cell (e.g. ONLY the 0.562550) ??
I am uploading the file in order to understand.
Thank you in advance

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

采纳的回答

Walter Roberson
Walter Roberson 2021-2-7
c = readcell('test.xlsx');
data = cellfun(@(C) str2double(regexprep(C, '\(.*', '')), c)

更多回答（1 个）

Ive J
Ive J 2021-2-7
编辑：Ive J 2021-2-7
x = readcell('test.xlsx')
nums = cellfun(@(x)sscanf(x, '%f', 1), x)
1.4420
0.3320
0.3560
0.8530
250.8690
8.8190
  2 个评论
Walter Roberson
Walter Roberson 2021-2-7
Good point. Though I might suggest adding a size to the sscanf() to prevent it from trying to look for more values, and as a guard against the possibility of having a second value that looked like a number in the cell.
Ive J
Ive J 2021-2-7
编辑：Ive J 2021-2-7
True, this works only for simple situations like this. Otherwise, regexp would guard against those sloppiness with sscanf and more complex formats. Now I've modified it, tanx!

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by