topic Re: Attribute Assistant question in State & Local Government Questions https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155134#M937 <HTML><HEAD></HEAD><BODY><SPAN>You can delete the Value Info field and recreate it as a larger field or split the expression into multi rows.</SPAN></BODY></HTML> Thu, 30 Aug 2012 17:37:00 GMT MikeMillerGIS 2012-08-30T17:37:00Z Attribute Assistant question https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155133#M936 <HTML><HEAD></HEAD><BODY><SPAN>Hey all,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>(IIf([STREET_TYP]="WAY","WY",IIf([STREET_TYP]="CIR","CI","Null"))) </SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Is there any other expression I could use that fits into 254 characters, or a different way in general?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Thu, 30 Aug 2012 13:11:53 GMT https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155133#M936 TimWitt 2012-08-30T13:11:53Z Re: Attribute Assistant question https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155134#M937 <HTML><HEAD></HEAD><BODY><SPAN>You can delete the Value Info field and recreate it as a larger field or split the expression into multi rows.</SPAN></BODY></HTML> Thu, 30 Aug 2012 17:37:00 GMT https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155134#M937 MikeMillerGIS 2012-08-30T17:37:00Z Re: Attribute Assistant question https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155135#M938 <HTML><HEAD></HEAD><BODY><SPAN>How can I split it into multiple rows?</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Thu, 30 Aug 2012 18:23:38 GMT https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155135#M938 TimWitt 2012-08-30T18:23:38Z Re: Attribute Assistant question https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155136#M939 <HTML><HEAD></HEAD><BODY><SPAN>I just created a bigger Value field, thanks for answering.</SPAN></BODY></HTML> Fri, 31 Aug 2012 13:42:56 GMT https://community.esri.com/t5/state-local-government-questions/attribute-assistant-question/m-p/155136#M939 TimWitt 2012-08-31T13:42:56Z