清空筛选条件
清空筛选条件

How to detect any unsupported character other than number

3 次查看（过去 30 天）
Aditya
Aditya 2012-1-31
编辑： Matt J 2013-10-1
I have series of data in my excel file. But there are some unsupported characters present in the file like 1 0, 0h0,0.>68,1L1 etc. I want to detect all of these using regular expression or any method and replace it by zero. My main moto is detect anything which is not a number and replace it by zero.

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

回答（1 个）

Walter Roberson
Walter Roberson 2012-1-31
L(L < '0' | L > '9') = '0';
  2 个评论
Walter Roberson
Walter Roberson 2012-2-6
L is the character string.
The code detects anything that is not a number and replaces it with 0.
The digits are all together as characters, in the order '0' '1' '2' '3' '4' '5' '6' '7' '8' '9' . So anything less than '0' is not a digit and anything greater than '9' is not a digit.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by