How to remove a decimal in an area dimension column?

Golfoholic · 2022-02-25T19:47:28+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Dataset

Magic ETL

Accepted answers

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.

All comments

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!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of