topic Re: calculation for turn HEX to decimal in survey123 connect? in ArcGIS Survey123 Questions

calculation for turn HEX to decimal in survey123 connect?

anonymous55 — Wed, 11 Oct 2023 20:58:47 GMT

Hello

I need to turn Hex number to decimal values in survey123 connect for one question?

do we have any formula or work around to achieve this?

Best

Re: calculation for turn HEX to decimal in survey123 connect?

MobiusSnake — Wed, 11 Oct 2023 21:07:14 GMT

Is everyone using the form in your organization? If so, you could use a JavaScript function, JS can convert hex to decimal pretty easily

Re: calculation for turn HEX to decimal in survey123 connect?

abureaux — Thu, 12 Oct 2023 14:47:22 GMT

Should be doable via calculates.

From https://www.binaryhexconverter.com/hex-to-decimal-converter

Re: calculation for turn HEX to decimal in survey123 connect?

anonymous55 — Fri, 13 Oct 2023 15:43:07 GMT

@MobiusSnake Hey unfortunately I don't know JS. 😞

Re: calculation for turn HEX to decimal in survey123 connect?

anonymous55 — Fri, 13 Oct 2023 16:02:17 GMT

Thanks @abureaux do you know how can I use this calculation in survey123 Calculate field.

Re: calculation for turn HEX to decimal in survey123 connect?

Raul — Fri, 13 Oct 2023 17:34:13 GMT

You could use the parseInt() javascript function to convert hex numbers to integers.

function hexToInt(hex) { return parseInt(hex, 16); }

Then use the survey123 calculation:

pulldata("@javascript", "functions.js", "hexToInt", ${your_hex_field})

Re: calculation for turn HEX to decimal in survey123 connect?

abureaux — Fri, 13 Oct 2023 19:09:07 GMT

While java can do this with less steps, not everyone can use Java in their environment. To do this inside of S123 natively, you can use the attached (at least as a starting point).

input_txt
Your HEX input (only built it for 4 digits, but didn't add a bind::esri:fieldLength).

input_stuff
These calculates isolate the positions of the characters. E.g., substr(${input_txt}, 2, 3) will grab the third character of the string within input_txt. It starts from 0, and reads left to right.

convert_stuff
Will convert the alpha character (A to F) into a decimal number (10 to 15), or return the decimal number (0 to 9) without changing it.

calculate_stuff
multiplies the number by 16^x, where x is the position (This will explain better than me)

output_txt
Your decimal output

S123:

Verification:

Two things:

You can simplify what I have done. I just have all the steps broken down and visible like that so you can see what it is doing. I also stopped at 4 digits because the pattern should be visible from that point.
I kind of messed up my original workflow. The 4 calculates under the input_stuff group were originally in reverse order. Rather than redo everything, I choose to swap their order (see below), which fixed everything. I am telling you this because, unfortunately, this adds an extra step for anyone that wants to expand this beyond 4 digits. Sorry!