topic Validate_Attribute_Lookup adds trailing whitespace in State & Local Government Questions

Validate_Attribute_Lookup adds trailing whitespace

CraigCarsley — Fri, 21 Feb 2014 18:28:51 GMT

Has anyone noticed that the Validate_Attribute_Lookup method seems to add a space to the end of an attribute value?
When I use it to validate a street name from the MasterStreetName table, it adds a trailing space to the value.

I don't believe this was happening before I started incorporating the MUNICIPALITY field as part of the same method.
I've eliminated the possibility that the space exists in the MasterStreetName table.

Anyone have any thoughts on this?

Re: Validate_Attribute_Lookup adds trailing whitespace

CraigCarsley — Mon, 10 Mar 2014 12:47:43 GMT

I think I've figured this out...

I've included the MUNICIPALITY field in my Validate_Attribute_Lookup method.
It seems that the Attribute Assistant will add a trailing space to a Street Name when the MUNICIPALITY field value is blank.
So, in cases where the MUNICIPALITY was not calculated prior to the method running, I see the white space.

To resolve this, I set a higher-priority, Intersecting_Feature method to confirm the MUNICIPALITY directly prior to running the Validate_Attribute_Lookup.

It has been working fine, ever since.