str2double function for HEX values

I'm using str2doule to converter a cell with mixed value types. the input may be 0.123 or 0x1a, 0x1A, 0xAB, 0X1a, 0x1A, 0xAB.

I found str2double("0x1a") can return the right result 26, but str2double("0x1e") will return NaN.

The test is under version '9.11.0.2911900 (R2021b) Update 8'.

Is any other suggested way to converter values like this.

Thanks.

[Stephen23]

"I found str2double("0x1a") can return the right result 26, but str2double("0x1e") will return NaN."

Apparently because the exponent gets detected before the base. See also:

https://www.mathworks.com/matlabcentral/answers/1450524-challanges-representing-hexadecimal-values-as-integer-double-in-uitable

[Paul]

The underlying issue is with sscanf with %f FormatSpec as called from str2double.

With %f, the sscanf doc page says that numeric field type is a "floating point number."

The str2double doc says "Text that represents a number can contain digits, a comma (thousands separator), a decimal point, a leading + or - sign, an e preceding a power of 10 scale factor ..."

Based on the doc pages should we expect str2double to correctly process hex strings? I'm not sure (even though it does for any input that does not end in "e")?

Also, the doc recommendation to replace str2double() with double(string()) dosn't work with hex strings

str2double({'0x1'})

ans = 1

double(string({'0x1'}))

ans = NaN

Answer 1

[Stephen23]

C = {'0.123', '0x1a', '0x1A', '0xAB', '0X1a', '0x1e', '12.5'};

V = cellfun(@convertValue, C)

V = 1×7

0.1230 26.0000 26.0000 171.0000 26.0000 30.0000 12.5000

<mw-icon class=""></mw-icon>

<mw-icon class=""></mw-icon>

function val = convertValue(txt)
val = str2double(txt);
if isnan(val)
    val = hex2dec(txt);
end
end