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