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

Allow multiple Replace functions in one Arcade expression

erica_poisson

It would be great if it was possible to utilize multiple replace functions in one Arcade expression in ArcGIS Online. Currently, only the last replace function is actually honored and the others are ignored. See example below:

Replace($feature["Gate_Number"], '51 east entrance', 'East Entrance')

Replace($feature["Gate_Number"], '54 middle entrance', 'Middle Entrance')

Replace($feature["Gate_Number"], '1', 'West Entrance')

Encuentra más publicaciones etiquetadas con

Status: Abrir

Comentarios

XanderBakker

There are a couple of ways you can do this already. See examples below:

<SPAN class="comment token">// simply add multiple lines each with one statement</SPAN>
<SPAN class="keyword token">var</SPAN> Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="string token">"51 east entrance, 1"</SPAN><SPAN class="punctuation token">;</SPAN>

Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>Gate_Number<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'51 east entrance'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'East Entrance'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>Gate_Number<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'54 middle entrance'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Middle Entrance'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>Gate_Number<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'West Entrance'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">return</SPAN> Gate_Number<SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍


<SPAN class="comment token">// nest the Replace funcion</SPAN>
<SPAN class="keyword token">var</SPAN> Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="string token">"51 east entrance, 1"</SPAN><SPAN class="punctuation token">;</SPAN>
Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>Gate_Number<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'51 east entrance'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'East Entrance'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'54 middle entrance'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Middle Entrance'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'West Entrance'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">return</SPAN> Gate_Number<SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍


<SPAN class="comment token">// create a list with all the search and replace values and loop through them</SPAN>
<SPAN class="keyword token">var</SPAN> Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="string token">"51 east entrance, 1"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> search_replace <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'51 east entrance'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'East Entrance'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'54 middle entrance'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Middle Entrance'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'West Entrance'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation 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>search_replace<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>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">var</SPAN> search_for <SPAN class="operator token">=</SPAN> search_replace<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">var</SPAN> replace_with <SPAN class="operator token">=</SPAN> search_replace<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp;&nbsp;&nbsp; Gate_Number <SPAN class="operator token">=</SPAN> <SPAN class="token function">Replace</SPAN><SPAN class="punctuation token">(</SPAN>Gate_Number<SPAN class="punctuation token">,</SPAN> search_for<SPAN class="punctuation token">,</SPAN> replace_with<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> Gate_Number<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

erica_poisson

Hi Xander,

I am trying to do this as a label expression, therefore each replace statement needs to apply to a label for one of three features. I don't see how the above statements could apply to this.

Thanks,
Erica

XanderBakker

If the label text does not contain the string, it will not replace anything. However, the last one that searches for a 1 and replaces (any coincidence) with the other text might cause problems. If the case is that you want to replace the entire (label) text, you shoud not use Replace. Is that the case?

erica_poisson

Hi Xander,

Sorry for the very late reply. Yes - it is the case where I want to replace the entire text (label) in each instance. So, the replacements would be:

1. Original text = '51 east entrance', replacement text = 'East Entrance'

2. Original text = '54 middle entrance', replacement text = 'Middle Entrance'

3. Original text = '1', replacement text = 'West Entrance'

AlexanderBaker

What about replacing multiple sections of text in one single attribute?

Ex. I want to replace the word "originals" with "" and I want to replace any " " with "%20".

I want to replace the word "originals" with no text and want to replace any spaces with %20 in order to create a valid url when creating a custom expression hyperlink to one of our virtual directory utilizing a source field with just a folder and file name.

Example....

..\originals\Archive\SwrWtr 02of06 87-10.tif

Want the data to look like this

\Archive\SwrWtr%2002of06%2087-10.tif

I've been able to successfully use the Replace function but not against multiple items within the same field.

Any suggestions? Each of these work below separately.... but I want to run multiple Replace functions against the same field $feature.SOURCE.

var a = Replace($feature.SOURCE, "originals", "");
return a;

var a = Replace($feature.SOURCE, " ", "%20");
return a;

AlexanderBaker

Figured it out... sharing expression for anyone else wanting to do a replace on multiple strings within one field...

var str = Replace($feature.SOURCE,'originals','');

var myURL = 'http://virtualdirectoryurl/';

myURL = myURL + Replace(str,' ','%20');

return myURL;

XanderBakker

Hi AJAMESBAKER_WPB , you may also want to look at the new function "UrlEncode(url)", which will encode any special character into a proper url valid character combination. You can also nest the replace functions in a single statement.

Únete a la Conversación

Inicia sesión para publicar, seguir contenido y más. ¿Nuevo aquí? Regístrate gratis.