nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Decimal to Binary Arcade Function

KristinJ

I’m interested in using Attribute Rules to calculate a field from decimal to binary on insert. I’m surprised that attribute rules don’t also support using python, but I digress already. My question is has anyone used Arcade to convert from decimal to binary? There doesn’t appear to be an existing bin(), or like in Excel dec2bin(), function in Arcade – is this on the road map for Arcade?

Encuentra más publicaciones etiquetadas con

Accepted answers

XanderBakker

Hi Kristin Judy ,

There is no standard Arcade function to do this currently and I have no idea if this is on the backlog. Something that might get you started is the code below. Please note that this does not handle the number of characters nor negative values as is done by Excel dec2bin():

<SPAN class="keyword token">function</SPAN> <SPAN class="token function">convertDecimalToBinary</SPAN><SPAN class="punctuation token">(</SPAN>n<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">// based on https://oamatech.com/javascript-decimal-to-binary-tutorial/</SPAN>
    <SPAN class="keyword token">var</SPAN> binary <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> temp <SPAN class="operator token">=</SPAN> n<SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> <SPAN class="number token">100</SPAN><SPAN class="punctuation token">;</SPAN> i<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>temp <SPAN class="operator token">%</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
            binary <SPAN class="operator token">=</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> binary<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
            binary <SPAN class="operator token">=</SPAN> <SPAN class="string token">"1"</SPAN> <SPAN class="operator token">+</SPAN> binary<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        temp <SPAN class="operator token">=</SPAN> <SPAN class="token function">Floor</SPAN><SPAN class="punctuation token">(</SPAN>temp <SPAN class="operator token">/</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>temp <SPAN class="operator token"><=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">return</SPAN> binary<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> <SPAN class="token function">convertDecimalToBinary</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Can you explain a little more what usage you have for this requirement?

All comments

KristinJ

Thanks, Xander Bakker! This is exactly what I’m looking for. We’re using GeoEvent Server to update feature services with vehicle location and path data. I’ll use this to convert a decimal “Status” value to binary on insert using Attribute Rules. This will allow us to extract information from the “Status” value provided by our AVL vendor to determine what vehicles are actually doing, not just where they are, e.g. street sweeping broom up or down (1=Low, 0=High). Per suggestion I’ve included the text and number functions to include leading zeros so we get a complete 16-bit binary number. Thanks again!

XanderBakker

Since the requirement was to get a 16 bit number, the last line can be changed to (replace "8223" with the variable field you want to apply the conversion to):

<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Number</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">convertDecimalToBinary</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">8223</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"0000000000000000"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

XanderBakker

Hi Kristin Judy ,

<SPAN class="keyword token">function</SPAN> <SPAN class="token function">convertDecimalToBinary</SPAN><SPAN class="punctuation token">(</SPAN>n<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">// based on https://oamatech.com/javascript-decimal-to-binary-tutorial/</SPAN>
    <SPAN class="keyword token">var</SPAN> binary <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> temp <SPAN class="operator token">=</SPAN> n<SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> <SPAN class="number token">100</SPAN><SPAN class="punctuation token">;</SPAN> i<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>temp <SPAN class="operator token">%</SPAN> <SPAN class="number token">2</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
            binary <SPAN class="operator token">=</SPAN> <SPAN class="string token">"0"</SPAN> <SPAN class="operator token">+</SPAN> binary<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
            binary <SPAN class="operator token">=</SPAN> <SPAN class="string token">"1"</SPAN> <SPAN class="operator token">+</SPAN> binary<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        temp <SPAN class="operator token">=</SPAN> <SPAN class="token function">Floor</SPAN><SPAN class="punctuation token">(</SPAN>temp <SPAN class="operator token">/</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>temp <SPAN class="operator token"><=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">return</SPAN> binary<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> <SPAN class="token function">convertDecimalToBinary</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Can you explain a little more what usage you have for this requirement?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.