Wildcard Search in Attribute Assistant Expression

MarkMorrison — Wed, 12 Jun 2019 19:18:22 GMT

How can I use a wildcard search term inside of the attribute assistant? I am trying to look in one field for the text string " WY" (The field might say "WINDY WY" or "MAIN ST", etc). If the search is successful, I want to populate another field based on findings so field 2 would say "WINDY WAY".

Input Fields:

Str_Name = "WINDY WY"

Str_Dir = "N"

Str_Numb = "123"

Unit = "#100"

Result Field:

USPS: = "123 N WINDY WAY #100"

To reiterate, I want to search the Str_Name field for specific street types, then based on that result populate the USPS field with a concatenated string using the proper street type abbreviation.

The thought it was important to explain the entire expression I want but I really only need help with the wildcard search

portion.

Re: Wildcard Search in Attribute Assistant Expression

VanessaSimps — Thu, 18 Feb 2021 15:58:42 GMT

Was there ever a resolution to this question? I am looking to do something similar!

topic Re: Wildcard Search in Attribute Assistant Expression in ArcGIS Solutions Questions

Wildcard Search in Attribute Assistant Expression

Re: Wildcard Search in Attribute Assistant Expression