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; } } }

ISNUMBER equivalent in Arcade

katshier

I'm wanting to recreate the below excel formula for labelling in a feature layer in Portal for ArcGIS v10.5.1. Is this possible using Arcade? I haven't found any similar functions to ISNUMBER?

=IF(ISNUMBER(FIND("-",C3)),RIGHT(C3,LEN(C3)-(FIND("-",C3)+1)),C3)

Najděte více příspěvků označených jako

Accepted answers

XanderBakker

Based on the test values you provided, the following expression will do:

<SPAN class="keyword token">var</SPAN> input <SPAN class="operator token">=</SPAN> <SPAN class="string token">"XX00 - Test"</SPAN> <SPAN class="comment token">// "XX02 - Test Avenue", "XXXA056 - Test Road", "Test Street", "XX56"</SPAN>
<SPAN class="keyword token">var</SPAN> array <SPAN class="operator token">=</SPAN> <SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"-"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">)</SPAN> <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">return</SPAN> <SPAN class="token function">Trim</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="token function">Trim</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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>

Obviously on line 1 you should point to the correct attribute using $feature.NameOfField

Please test and see if the cases you provided describe all the situations that might occur in the data.

All comments

XanderBakker

You can use a combination of several functions in Arcade like shown below:

<SPAN class="keyword token">var</SPAN> txt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"abc-123.5def"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> exceptions <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"-"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"."</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="comment token">// Console(Number(txt));</SPAN>
<SPAN class="keyword token">var</SPAN> keep <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><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="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>txt<SPAN class="punctuation token">)</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">var</SPAN> a <SPAN class="operator token">=</SPAN> <SPAN class="token function">Mid</SPAN><SPAN class="punctuation token">(</SPAN>txt<SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="comment token">// Console(i + ": " + a);</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">IndexOf</SPAN><SPAN class="punctuation token">(</SPAN>exceptions<SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">!=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        keep <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> a<SPAN class="punctuation token">;</SPAN>
        <SPAN class="comment token">// Console(" - Keep (1):" + a);</SPAN>
    <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">IsNan</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Number</SPAN><SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> False<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        keep <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> a<SPAN class="punctuation token">;</SPAN>
        <SPAN class="comment token">// Console(" - Keep (2):" + a);</SPAN>
    <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="comment token">// Console(" - Eliminating:" + a);</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> <SPAN class="token function">Number</SPAN><SPAN class="punctuation token">(</SPAN>keep<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>

Obviously, this will fail completely in case you have something like "a-3bcd-65.32efd0.2". So, maybe you can provide some examples of what you have as input and what you are trying to obtain.

katshier

Thanks Xander, here's an example of the type of data we have. Each item has an id e.g XX05 or a name or both. Ideally we would want only the name where available but if there's no name then the id will be used.

Input	Output
XX00 - Test	Test
XX02 - Test Avenue	Test Avenue
XXXA056 - Test Road	Test Road
Test Street	Test Street
XX56	XX56

XanderBakker

Based on the test values you provided, the following expression will do:

<SPAN class="keyword token">var</SPAN> input <SPAN class="operator token">=</SPAN> <SPAN class="string token">"XX00 - Test"</SPAN> <SPAN class="comment token">// "XX02 - Test Avenue", "XXXA056 - Test Road", "Test Street", "XX56"</SPAN>
<SPAN class="keyword token">var</SPAN> array <SPAN class="operator token">=</SPAN> <SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"-"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">)</SPAN> <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">return</SPAN> <SPAN class="token function">Trim</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="token function">Trim</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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>

Obviously on line 1 you should point to the correct attribute using $feature.NameOfField

Please test and see if the cases you provided describe all the situations that might occur in the data.

katshier

That works well for the examples I provided, thanks Xander. I did notice some records have a double hyphen for example: XX000 - Test Avenue-Test District for those I would want everything after the first ' - ' so I used a concatenate which seems to do the trick unless you have a more sophisticated way of doing this?

<SPAN class="keyword token">var</SPAN> input <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>name 
<SPAN class="keyword token">var</SPAN> array <SPAN class="operator token">=</SPAN> <SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"-"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">)</SPAN> <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">return</SPAN> <SPAN class="token function">Trim</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="token function">Concatenate</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">,</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">}</SPAN> 
<SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="token function">Trim</SPAN><SPAN class="punctuation token">(</SPAN>array<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</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>

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Všechny komunity
Nedávné příspěvky
Sledovaný obsah
Pomoc komunity

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