How to check and convert a column of strings to numbers

Question

Leon 2020-4-8

评论： Leon 2020-4-8

I have some column data like this:

   A = 
    "3"
    "3"
    "31"
    "31"
    "57"
    "58"

or this

    A =
    "A05"
    "C100"
    "G5"
    "H33"

Would you please help me with two questions?

(1) How do I check if A can be converted to numers (1 to the first A and 0 to the 2nd A)?

(2) Once I know that, how do I convert them to numerical values?

Thanks.

Answer 1

Tommy 2020-4-8

(2) Convert any string to a double using str2double. "If str2double cannot convert text to a number, then it returns a NaN value."

D = str2double(A);

(1) Check if any element in the result is NaN:

all(~isnan(D))

Leon 2020-4-8

Excellent! Many thanks!