How to detect any unsupported character other than number

1 visualización (últimos 30 días)
Aditya
Aditya el 31 de En. de 2012
Editada: Matt J el 1 de Oct. de 2013
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.

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Walter Roberson
Walter Roberson el 31 de En. de 2012
L(L < '0' | L > '9') = '0';
  2 comentarios
Aditya
Aditya el 6 de Feb. de 2012
Can you please clarify your answer
Walter Roberson
Walter Roberson el 6 de Feb. de 2012
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.

Iniciar sesión para comentar.

Categorías

Más información sobre MATLAB Report Generator en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by