topic Re: how to remove decimal point in Application Development and Automation Discussions

how to remove decimal point

Former Member — Tue, 15 Jan 2008 15:03:30 GMT

Hi Guys,

I want to remove decimal point in quantity field

e.g instead 5.0000, it should print 50000.

can any one suggest what to be done.

Thanks in advance for your help.

Re: how to remove decimal point

Former Member — Tue, 15 Jan 2008 15:10:39 GMT

try this...


    DATA : l_quntity(16).

    l_quntity  = itab-menge.  "quntity field 5.0000

    REPLACE ALL OCCURRENCES OF '.' IN l_quntity WITH SPACE.
    CONDENSE l_quntity.

    WRITE l_quntity.

Re: how to remove decimal point

RichHeilman — Tue, 15 Jan 2008 15:11:24 GMT

Sure try this.



data: p_fld type p decimals 4.
data: c_fld(15) type c.

c_fld = p_fld.
translate c_fld using '. '.
condense c_fld no-gaps.

You could also find the number of decimals places, and then multiple by 10, 100, 1000, etc

Regards,

Rich Heilman

Re: how to remove decimal point

Former Member — Tue, 15 Jan 2008 15:12:10 GMT

Goto Menu option

System - User Profile - Own Data

Tabstrip Defaults

Change Decimal Notation to 1234567,89, that will remove the decimal point.

You might have to log out and back on before it takes effect.

Hope that helps,

Michael

Re: how to remove decimal point

Former Member — Tue, 15 Jan 2008 15:12:54 GMT

Hi,

Use syntax REPLACE ALL OCCURANCES OF ',' in <field Name> with ''.

CONDENCE <field name> no-gaps.

Regards,

Satish

Re: how to remove decimal point

Former Member — Tue, 15 Jan 2008 15:13:46 GMT

SPLIT f AT '.' INTO f1 f2.

Concatenate f1 f2 into f3.

Regards,

Mohan

Re: how to remove decimal point

Former Member — Tue, 15 Jan 2008 15:16:12 GMT

Hi Imran

Write that fields with "decimals 0" option in Write statement.

Cheers

~ Ranganath

Re: how to remove decimal point

Former Member — Tue, 15 Jan 2008 15:23:25 GMT

Thanks for your kindly help.