Effacer les filtres
Effacer les filtres

How to detect any unsupported character other than number

3 vues (au cours des 30 derniers jours)
Aditya
Aditya le 31 Jan 2012
Modifié(e) : Matt J le 1 Oct 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.

Connectez-vous pour répondre à cette question.

Réponses (1)

Walter Roberson
Walter Roberson le 31 Jan 2012
L(L < '0' | L > '9') = '0';
  2 commentaires
Aditya
Aditya le 6 Fév 2012
Can you please clarify your answer
Walter Roberson
Walter Roberson le 6 Fév 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.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Logical dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by