Convert Hex to Decimal

Tyson
Tyson Member
in Magic ETL

I have a hex data point that I need to parse and convert to numeric values.  Has anyone done this and what would someone recommend?  SQL?

Comments

  • ST_Superman
    ST_Superman Domo Employee

    You would need to do this in a MySQL dataflow, but I believe you can use the CONV() function there

     

    SELECT
    CONV(`hex field`,16,10) as `decimal field`

Categories