topic Re: Split and Rearrange Text With Arcade? in Developers Questions

Split and Rearrange Text With Arcade?

deleted-user-1_r2dgYuILKY — Wed, 01 May 2019 16:00:59 GMT

I have fields with names in the format last, first, middle initial. I would like to display them as first, ME, last. Is this possible in Arcade using the Split function?

Re: Split and Rearrange Text With Arcade?

KenBuja — Sat, 11 Dec 2021 13:23:55 GMT

How is your data formatted? If it's in a field as "Smith, John A" then you can use

var arrName = split($feature.name, ",")
return arrName[1] + " " + arrName[0]‍‍‍‍‍‍‍‍‍‍

This returns "John A Smith"

Re: Split and Rearrange Text With Arcade?

deleted-user-1_r2dgYuILKY — Wed, 01 May 2019 17:19:37 GMT

There's no comma just spaces, but this works. Thanks!

Re: Split and Rearrange Text With Arcade?

KenBuja — Wed, 01 May 2019 17:27:07 GMT

Glad to help. Don't forget to click the "Mark Correct" button.

Re: Split and Rearrange Text With Arcade?

SarahHartholt — Mon, 08 Mar 2021 21:00:50 GMT

I have created a Cell_ID field to store grid index values in a road feature class. For example, if Main St. falls within grid cells B1, B2, C2 & C3, my Cell_ID field is populated with "C3,B2,C2,B1". Is there any way for me to reorder the values alphabetically and then numerically as B1, B2, C2 & C3?

Solved my problem below:

var arrName = split($feature.Cell_ID, ",") return concatenate(sort(arrName))