Concat Formatting

Options
ColinHaze
ColinHaze Member
edited July 7 in Calculations & Variables (Beast Mode)

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

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories