Extra Spacing from Exporting to Excel

SLam
SLam Member
in Charting

Hello,

I have this issue where when I export to Excel, there is about 6 extra spaces at the end of each result.. When I export a card into Excel and click on a cell in the FirstName column, it'll show for example, "Max__", where _ = spaces.

Is there any way to get rid of this?

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    The export should just mimicking what is in your actual data, so I suspect you have trailing spaces in your source data. You can easily fix this in Magic ETL or with a Beast Mode by using the TRIM function to eliminate any leading or trailing spaces.

    **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 ✓

    The export should just mimicking what is in your actual data, so I suspect you have trailing spaces in your source data. You can easily fix this in Magic ETL or with a Beast Mode by using the TRIM function to eliminate any leading or trailing spaces.

    **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