Select to view content in your preferred language

Split values in a single filed using Arcade

800
1
Jump to solution
09-14-2023 01:53 PM
TimHayes3
Frequent Contributor

I have a table with Field1. Field1 has values in it like these:

21223 Streets Pavement

23432 Parks Forestry

232112 Building Inspections

542134 Fire Prevention

 

How would I split the values in this field so that 21223, Streets, and Pavement would be separate values in the popup that would look like this:

Vehicle Number: 21223

Department: Streets

Division: Pavement

0 Kudos
1 Solution

Accepted Solutions
SteveCole
Honored Contributor

If the data in Field1 is consistent, you can use the Split Arcade function to split the Field1 value based on spaces into an array. Then you can building your popup how you see fit.

View solution in original post

1 Reply
SteveCole
Honored Contributor

If the data in Field1 is consistent, you can use the Split Arcade function to split the Field1 value based on spaces into an array. Then you can building your popup how you see fit.