AnsweredAssumed Answered

Remove spaces from route identifier in route event

Question asked by khubbard on Dec 12, 2014
Latest reply on Dec 12, 2014 by swenwaschk

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.

 

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.

 

Is there any way to remove the spaces like using a variable created with SQL somewhere like SELECT REPLACE(Route identifier, ' ','')?

 

any help is greatly appreciated

Outcomes