Hi, I was wondering, once I have loaded the orders to my vehicle routing problem, is it possible to modify them at all? Sometimes when I load them from a geocoding result I have got from my Excel sheet, there have been extra spaces after the order names (in the original Excel document) which causes an error with the routing, but when I try to click on the order properties, it won't show the extra spaces and no matter what I do, I still get the error. I have to close ArcMap and then open the Excel document, modify the names, re-open the program, geocode the addresses and then load the orders again. Is this the only way or is there a way to modify the geocoded results in the program itself? I'm still relatively new to this.
Solved! Go to Solution.
You can remove spaces by calculating the field and using the rtrim()-function.
You can remove spaces by calculating the field and using the rtrim()-function.