Concat Formatting

ColinHaze

Hi,

I am having a hard time removing the spaces at the end of one of my columns.

The beastmode im using is CONCAT(Consignee Address,', ',CONSIGNEE_CITYNAME,', ',CONSIGNEE_STATE).

Some rows have a lot of spaces behind the consignee address and ends up looking like this

3835 KNIGHT RD , Memphis, TN

MarkSnodgrass

you can add a TRIM() function around the entire concat function and that will remove trailing spaces. You can also do it around each field, which may help.

MarkSnodgrass

you can add a TRIM() function around the entire concat function and that will remove trailing spaces. You can also do it around each field, which may help.