Arcade Trim leaving field qualifiers

AaronCraig2

Hi, I am performing the following arcade expression in the Data webpage under the feature service in ArcGIS online:

Trim(Text(Split($feature["FULL_ADDRESS"], $feature["HOUSE_NO_LABEL"], 1, 0)))

As you can see from the image, the resulting string is left with the field qualifiers. Are my methodologies causing the issue or is this an arcade bug?

Cheers,

Aaron

kenbuja

It's actually returning an array of one item, consisting of the string. To get that item, you have to use this syntax

<SPAN class="keyword token">var</SPAN> array <SPAN class="operator token">=</SPAN> <SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FULL_ADDRESS"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"HOUSE_NO_LABEL"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</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><SPAN class="token function">Text</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>‍‍

or 

<SPAN class="token function">Trim</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Split</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FULL_ADDRESS"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"HOUSE_NO_LABEL"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><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><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>