Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Remove commma from my column value
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
Answers
-
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.
0 -
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?
0