Attribute Assistant question

[TimWitt]

Hey all,

I am using Attribute Assistant for maintaining an address point layer. I work for E911 and our county uses 2 different 911 software, each have different needs in how the Street Type is abbreviated. For example one needs to have "WAY" spelled out and the other only allows two characters so "WAY" needs to be "WY". So i have 2 columns, one for each 911 software.

With the attribute assistant my work got a lot easier, but I still have to type in both types of street types. To only have to type it in once I figured I could write an expression to check the first field and then auto populate the second.

(IIf([STREET_TYP]="WAY","WY",IIf([STREET_TYP]="CIR","CI","Null")))

This would work, but the problem I have is that the field in the dynamic value table only allows 254 characters and I have 15 Street types that need to be translated.

Is there any other expression I could use that fits into 254 characters, or a different way in general?

Thanks!

[MikeMillerGIS · Accepted solution]

You can delete the Value Info field and recreate it as a larger field or split the expression into multi rows.

[TimWitt]

How can I split it into multiple rows?

Thanks

[TimWitt]

I just created a bigger Value field, thanks for answering.