Skip to content

Hex.ToInt

Converts a hexadecimal string to its integer value

EvaluationContext.Colour.Hex.ToInt( hex )
Parameter Type Required Description
hex STRING The hex value to convert (e.g., "1A")

INT64 Integer value of the hex string

EvaluationContext.Colour.Hex.ToInt("FF") // Returns 255

function 'EvaluationContext.Colour.Hex.ToInt' =
        (
            hex: STRING
        ) =>

            VAR CleanHex = IF( LEFT( hex, 1 ) = "#", MID( hex, 2, LEN( hex ) - 1), hex )
            VAR Result =
                SUMX(
                    GENERATESERIES( 1, LEN( CleanHex ) ),
                    VAR Pos = [Value]
                    VAR c = MID( CleanHex, Pos, 1 )
                    VAR DigitValue = SWITCH( UPPER( c ), "A", 10, "B", 11, "C", 12, "D", 13, "E", 14, "F", 15, VALUE( c ) )
                    RETURN
                        DigitValue * POWER( 16, LEN( hex ) - Pos )
                )

            RETURN Result