Concat Formatting

ColinHaze · 2023-12-13T20:26:10+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

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.

All comments

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of