Fail to convert string to a number

3 vues (au cours des 30 derniers jours)
Mallory Morton
Mallory Morton le 20 Déc 2019
Commenté : Adam Danz le 20 Déc 2019
I've read in a Word Document and split the text based on certain delimiters. One of the strings i'm simply trying to convert to a number is " 329.3 " observing what appears to be a space character at the beginning and end of the string.
When I use str2double it converts it to "NaN". Normally leading and trailing whitespaces allow for conversion to a double with no problem.
If I run the isspace command it returns "1 0 0 0 0 0 0" so the last character is my issue, it isn't showing up as a whitespace character.
The strtrim command returns the string "329.3 " with only the leading whitespace removed. Strrep with attempting to replace the space returns the same result.
When I run the isstrprop command for each character Category the only one that returns true is the "print" category, "wspace" does not return true but for hte first character. Any ideas as to why the last character would not be showing up as a white space, isn't removeable, and prevents conversion from a string to a double?
  1 commentaire
Adam Danz
Adam Danz le 20 Déc 2019
Very well explained! +1

Connectez-vous pour commenter.

Réponse acceptée

Fangjun Jiang
Fangjun Jiang le 20 Déc 2019
Modifié(e) : Fangjun Jiang le 20 Déc 2019
use double() to see the ASCII value
a=[char(32),'3.93',char(10)];
double(a)
  2 commentaires
Mallory Morton
Mallory Morton le 20 Déc 2019
It shows it is char 160 which is a non-breaking space character. Is there a way to manage those characters with MATLAB so that I can convert the string to a number? (strtrim doesn't remove significant whitespace characters)
Fangjun Jiang
Fangjun Jiang le 20 Déc 2019
strrep(YourStr,char(160),'')

Connectez-vous pour commenter.

Plus de réponses (1)

Adam Danz
Adam Danz le 20 Déc 2019
For those who are trying to recreate the problem,
t = [' 3.93',char(160)];
One solution is to use a regular expression to extract the numeric content.
n = regexp(t,'\d*\.?\d*','match')

Catégories

En savoir plus sur Characters and Strings dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by