cancel
Showing results for 
Search instead for 
Did you mean: 

Remove commas in number format

Former Member
0 Kudos

I created a information space with a YearMonth Object and a Msr object.

When I open the information space the YearMonth Object has a comma.

I formatted the YearMonth as Numeric in the IDT tool and still see a comma when I open the information space.

I appreciate if any one can reply with a solution  how to remove comma when viewing the information space.

Output in Information Space

YearMonth       Msr

201,412            100

201,411            50

201,410            150

201,409            200

Preferred Output in Information Space

YearMonth       Msr

201412            100

201411            50

201410            150

201409            200

Accepted Solutions (0)

Answers (1)

Answers (1)

charlesreed
Advisor
Advisor
0 Kudos

Try a varchar datatype for your YearMonth object for use in your Information Space.