Validate_Attribute_Lookup adds trailing whitespace

404
1
02-21-2014 10:28 AM
Labels (1)
CraigCarsley
Occasional Contributor II
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?
0 Kudos
1 Reply
CraigCarsley
Occasional Contributor II
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.
0 Kudos