topic Modifying the order data in NA in ArcGIS Network Analyst Questions https://community.esri.com/t5/arcgis-network-analyst-questions/modifying-the-order-data-in-na/m-p/360492#M3370 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 21 Jul 2014 12:12:14 GMT SuviMansikkamaki 2014-07-21T12:12:14Z Modifying the order data in NA https://community.esri.com/t5/arcgis-network-analyst-questions/modifying-the-order-data-in-na/m-p/360492#M3370 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 21 Jul 2014 12:12:14 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/modifying-the-order-data-in-na/m-p/360492#M3370 SuviMansikkamaki 2014-07-21T12:12:14Z Re: Modifying the order data in NA https://community.esri.com/t5/arcgis-network-analyst-questions/modifying-the-order-data-in-na/m-p/360493#M3371 <HTML><HEAD></HEAD><BODY><P>You can remove spaces by calculating the field and using the rtrim()-function.</P></BODY></HTML> Mon, 21 Jul 2014 14:40:42 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/modifying-the-order-data-in-na/m-p/360493#M3371 TimSemmelhaack 2014-07-21T14:40:42Z