Converting a string type hex number to a decimal?

Working with Data
1

Is there an aggregation operator that can convert a string type hex to a decimal? We are working with blockchain data and have run into cases like this quite often.

2

Hi @Kuan_Huang,

Welcome to MongoDB community!

Have you tried to use a $convert or $toDouble operator in a project or addFields stage?

Best
Pavel

3

That works. Thank you!

4

case 2:

Screen Shot 2020-10-21 at 10.27.52 PM
Screen Shot 2020-10-21 at 10.27.52 PM1486×942 72 KB

5

Actually there is a problem. It seems to work in below in case 1 but not in case 2:

case 1:

Screen Shot 2020-10-21 at 10.03.50 PM
Screen Shot 2020-10-21 at 10.03.50 PM1566×542 44.9 KB

6

Hi @Kuan_Huang ,

As you can see the projection stage preview results in no value for “b” therefore its null later.

I would use $addFields and have represantation of a binary string via the extended json represtation :

Thanks
Pavel

7

Thank you. I will find sometime to explore it and get back to you.

8

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.