How to remove a decimal in an area dimension column?

Golfoholic

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:

What I want is just the more standard:

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

MarkSnodgrass

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.

MarkSnodgrass

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.

Golfoholic

@MarkSnodgrass Brilliant. Thank you!