Fail to convert string to a number

11 Ansichten (letzte 30 Tage)
Mallory Morton
Mallory Morton am 20 Dez. 2019
Kommentiert: Adam Danz am 20 Dez. 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?

Akzeptierte Antwort

Fangjun Jiang
Fangjun Jiang am 20 Dez. 2019
Bearbeitet: Fangjun Jiang am 20 Dez. 2019
use double() to see the ASCII value
a=[char(32),'3.93',char(10)];
double(a)
  2 Kommentare
Mallory Morton
Mallory Morton am 20 Dez. 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 am 20 Dez. 2019
strrep(YourStr,char(160),'')

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Adam Danz
Adam Danz am 20 Dez. 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')

Kategorien

Mehr zu Characters and Strings finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by