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

How do I write an Arcade label expression to remove multiple (and inconsistent) leading characters from a field (e.g. !!, ^^, *)?

AmyEverett1

I have users who populate a field that is used to label features on a map that is used by many other users. I have no control over what/how they populate this field. For whatever reason, several users insist on proceeding the actual value with arbitrary special characters such as !!**, !***, ^^**, *** (presumably for sorting purposes). The end users of the data do not wish to see these characters when used as labels in commonly used maps and apps. The leading characters differ all the time and I am having a hard time grasping how to replace multiple characters if/when needed.

Encontre mais publicações marcadas com

Accepted answers

XanderBakker

Hi Amy Everett ,

I those characters always have to be removed no matter the position of these characters, you could use Replace. See the example below:

<SPAN class="keyword token">var</SPAN> txt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"!!**!***hello world^^*****"</SPAN><SPAN class="punctuation token">;</SPAN>
txt <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>txt<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="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="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="keyword token">return</SPAN> txt<SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This will return "hello world".

If your use case is different, could you provide some examples to see what needs to be done?

All comments

XanderBakker

Hi Amy Everett ,

I those characters always have to be removed no matter the position of these characters, you could use Replace. See the example below:

<SPAN class="keyword token">var</SPAN> txt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"!!**!***hello world^^*****"</SPAN><SPAN class="punctuation token">;</SPAN>
txt <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>txt<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="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="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="keyword token">return</SPAN> txt<SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This will return "hello world".

If your use case is different, could you provide some examples to see what needs to be done?

JoeBorgione

There are seldom good technological solutions to behavioral problems.... Ed Crowely

AmyEverett1

Thank you, Xander! That was exactly what I was looking for! I didn't think about nesting them that way. I appreciate your assistance!

XanderBakker

Hi Amy Everett ,

Glad it works, but I want to emphasize what jborgion mentioned. Why do you have these characters in your data? Is there some part of the process you can change to avoid having these characters in your data?

JoeBorgione

That's exactly what I've been wondering as well. Sounds like a quick database tutorial for the users might be time well spent.

AmyEverett1

If I had any authority over the data structure, many things would be different! Unfortunately I am just the recipient who has to make it come together in the end.

AlexRudowski

I stumbled upon this thread when I was looking to remove part of a label from a feature field in a webmap. Here's what I ended up with:

//All labels are in Brighton with the same zip code. Expression removes town and zip code

var txt = $feature.Location
txt = Replace(txt, ", BRIGHTON, 84121", "");
return txt

Thanks!

StevePlettenberg

Dusted this off today. Still relevant. Super helpful!

Thank you!

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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