How to remove a decimal in an area dimension column?

Golfoholic
Golfoholic
in Magic ETL

I have a column that showing the dimensions of a unit. 5x5, 5x10, etc.. the column is in a text format and the data is coming in to Domo in a strange way, it looks like:

image.png

What I want is just the more standard:

5x5, 5x10, 5x15, etc.. In the ETL how could i get rid of the .0?

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You can use the formula tile and use the replace function like this:

    REPLACE(fielname,'.0','')

    This would replace .0 with nothing which would then make it read how you want.

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

Categories