I'm attempting to create an address block for a CSD pick ticket without blank lines. For example, if address lines 2 and 3 are blank, I want to see:
Name
Address line 1
City, State Zip
Instead of:
Name
Address line 1
City, State Zip
I have tried a few combinations of concatenating '
' between the strings and normalize-space() and translate(). What would be the best way to approach this?
Thank you!