Modifying the order data in NA

1518
1
Jump to solution
07-21-2014 05:12 AM
Highlighted
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.

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
New Contributor II

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

View solution in original post

Reply
0 Kudos
1 Reply
Highlighted
New Contributor II

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

View solution in original post

Reply
0 Kudos