Modifying the order data in NA

1580
1
Jump to solution
07-21-2014 05:12 AM
SuviMansikkamaki
New Contributor

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.

0 Kudos
1 Solution

Accepted Solutions
TimSemmelhaack
New Contributor III

You can remove spaces by calculating the field and using the rtrim()-function.

View solution in original post

0 Kudos
1 Reply
TimSemmelhaack
New Contributor III

You can remove spaces by calculating the field and using the rtrim()-function.

0 Kudos