Fail to convert string to a number
Afficher commentaires plus anciens
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
le 20 Déc 2019
Very well explained! +1
Réponse acceptée
Plus de réponses (1)
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 Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!