topic Re: Remove spaces from route identifier in route event in Mapping Questions https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479508#M5160 <HTML><HEAD></HEAD><BODY><P><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 12 Dec 2014 15:31:36 GMT SwenWaschk 2014-12-12T15:31:36Z Remove spaces from route identifier in route event https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479505#M5157 <HTML><HEAD></HEAD><BODY><P>I am trying to display a route event, but because of leading, trailing or intermediate spaces in the route identifier I only get about a tenth of the events displaying.</P><P></P><P>I am using a personal database and a route shape file, I can modify the personal database, but the problem is the inconsistancy in the shape file.</P><P></P><P>Is there any way to remove the spaces like using a variable created with SQL somewhere like SELECT REPLACE(Route identifier, ' ','')?</P><P></P><P>any help is greatly appreciated</P></BODY></HTML> Fri, 12 Dec 2014 12:50:07 GMT https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479505#M5157 kenhubbard 2014-12-12T12:50:07Z Re: Remove spaces from route identifier in route event https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479506#M5158 <HTML><HEAD></HEAD><BODY><P>Using the field calculator try:</P><P>!FieldName!.replace(" ", "")</P><P></P><P>That should take care of the spaces</P></BODY></HTML> Fri, 12 Dec 2014 13:19:37 GMT https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479506#M5158 SwenWaschk 2014-12-12T13:19:37Z Re: Remove spaces from route identifier in route event https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479507#M5159 <HTML><HEAD></HEAD><BODY><P>Never used Field Calculator before, whole new world of possibilities</P><P></P><P>Thank you!</P></BODY></HTML> Fri, 12 Dec 2014 15:08:20 GMT https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479507#M5159 kenhubbard 2014-12-12T15:08:20Z Re: Remove spaces from route identifier in route event https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479508#M5160 <HTML><HEAD></HEAD><BODY><P><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 12 Dec 2014 15:31:36 GMT https://community.esri.com/t5/mapping-questions/remove-spaces-from-route-identifier-in-route-event/m-p/479508#M5160 SwenWaschk 2014-12-12T15:31:36Z