AnsweredAssumed Answered

Attribute Assistant: I have a concatenated field that maintains blank spaces if a contributing field is null.  How would I eliminate the spaces left from missing pre-direction and post-direction values?

Question asked by jeffburton on May 19, 2017
Latest reply on Jul 31, 2017 by DAFoxFL

I have a the following value method in my dynamic value table#:

([ADDRNUM]+" "+[ROADPREDIR]+" "+[FULLNAME]+" "+[ROADPOSTDIR]+" "+[UNITTYPE]+" "+[UNITID])

When any of these values is null, the resulting concatenation contains extra spaces.  What would be the best way to ensure no extra spaces are created?

 

Thanks

Outcomes