Fail to convert string to a number
1 view (last 30 days)
Show older comments
Mallory Morton
on 20 Dec 2019
Commented: Adam Danz
on 20 Dec 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?
Accepted Answer
Fangjun Jiang
on 20 Dec 2019
Edited: Fangjun Jiang
on 20 Dec 2019
use double() to see the ASCII value
a=[char(32),'3.93',char(10)];
double(a)
2 Comments
More Answers (1)
Adam Danz
on 20 Dec 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')
0 Comments
See Also
Categories
Find more on Characters and Strings in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!