Remove commma from my column value

Question

Hi,

I have column Number datatype.

Which hold number like this 12,345,678

I need to format it as 12 345 678 which means need to replace comma(,) with space.

Please help me how can I format the same, tried with REPLACE(column_name, ',','') but not working.

I am using OBIEE Version 12.2.1.2

Regards,

Mahesh

Pedro F · Answer

Take a look here, this should help you.

Maheshkumar Jadhav · Answer

Hi Pedro,

Thanks for reply!!

I need exactly the same as you stated....instead of comma I need spaces.

can you please help how can I put the custom mask in column properties box...any standard code for it?

Pedro F · Answer

If you column's datatype is actually a number, then you don't have to do any replacement since those commas are just a visual representation of the numerical value.

If you go to column properties -> data format, you can uncheck the box of "Use 1000's separator" and you won't have those columns. If you need spaces, instead of commas, you can use a custom mask to achieve that.