| Format Mask Problem [message #602395] |
Wed, 04 December 2013 00:14  |
 |
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
|
Senior Member |
|
|
Hi,
I have a text item which is a number field, i like to display the format as
999,999,999.99, so i set the format mask in property palette as mentioned,
but its adding some spaces on the left side, so how to remove the spaces?
|
|
|
|
|
|
|
|
|
|
| Re: Format Mask Problem [message #602438 is a reply to message #602404] |
Wed, 04 December 2013 06:25  |
 |
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
|
Senior Member |
|
|
yes whatever @littlefoot sir suggested that is recommended b'coz in above format which you have posted like 999,999,999.99 if you enter only digit it will add spaces at left side then you will have to TRIM.
select to_char(99999,'99,999,999,999.00') from dual
select ltrim(to_char(99999,'99,999,999,999.00')) from dual;
REgard
mughal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
