Converting Hex string (i.e., 0xFF, 0x0AB) to Decimal

[uksong]

Hello,

Is there any fancy command to convert Hex string to Decimal?
I can find some examples but it does not perfectly match with my cases.

My case (with “0x” prefix or sometimes “0” is included between “0x” and the actual value part:
0xFF (hex string) -> 255 (decimal)
0x0AB (hex string) -> 171 (decimal)

The examples I found (no “0x” prefix):
FF -> 255
AB -> 171

If there is no fancy command then what I can do is to remove “0x” or “0x0” from the string and convert.
Thanks.

[ScottF]

Hi @uksong -

Welcome to the forum. You can do this using an R Snippet node with just a couple of lines of code, using the R strtoi() function:

Example workflow attached:

HextoDecimal_RSnippet.knwf (6.0 KB)

[AlexanderFillbrunn]

Hi @uksong,
and in case you don’t want to use R, you can also use the KNIME column expression with the following snippet:

parseInt(column("YourHexStringColumn"), 16)

Kind regards
Alexander