Remove spaces from route identifier in route event

[kenhubbard]

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

[SwenWaschk · Accepted solution]

Using the field calculator try:

!FieldName!.replace(" ", "")

That should take care of the spaces

[kenhubbard]

Never used Field Calculator before, whole new world of possibilities

Thank you!

[SwenWaschk]

🙂