turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Hexadecimal to decimal

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 29, 2016 12:01 AM
(5131 views)

I have a column that has number in the format of 0x1, 0x5, 0xe - how do I convert these hexadecimal to decimal?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Just change the column data type to numeric (works in JMP 12, maybe earlier versions too).

If you want to keep the hex column as strings for reference you could create a numerical column with the simple formula Num**(**:hexcol**)**.

If it does not work try this formula (change "hexcol" to the name of you column):

Hex To Number**(**Substr**(**:hexcol, **3****))**

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Just change the column data type to numeric (works in JMP 12, maybe earlier versions too).

If you want to keep the hex column as strings for reference you could create a numerical column with the simple formula Num**(**:hexcol**)**.

If it does not work try this formula (change "hexcol" to the name of you column):

Hex To Number**(**Substr**(**:hexcol, **3****))**

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

The first two do not work.

The last formula works.

That was the first thing I tried to do , but it did not like tha input arguments.

I tried using Munger, but looks like Substr is the right way to go.

Thanks a lot!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

In JMP 12.2 for Mac I can just type for example *0x1e4* in a numeric column and it will automatically transform into a decimal number.

I just tried doing the same in JMP 12.01 for Windows but it did not work, which may explain why my first two suggestions did not work for you.

Probably a unix only thing.