topic Re: Value change in Application Development and Automation Discussions

Value change

Former Member — Tue, 23 Dec 2008 05:43:10 GMT

Hi,

I got output like 1,308,040.00. But I want output like this 1308040.00. How to destroy the , .Please help me...

Former Member — Tue, 23 Dec 2008 05:44:36 GMT

Hi,

We have Replace statement use that for the variable.

Regards,

Naresh

SuhaSaha — Tue, 23 Dec 2008 05:50:19 GMT

Hello Dorothy,

The qn has been asked innumerable times in SDN forum.

Just FYI, in reports you can use the addition NO-GROUPING

 WRITE v_number NO-GROUPING.

& in scripts you can use

 /: &V_NUMBER(T)&

Hope I did not draw the wrath of the moderators, plz make a point of searching SDN from now on )

BR,

Suhas

Former Member — Tue, 23 Dec 2008 05:50:59 GMT

Hi,

use this,

TRANSLATE v_base_quantity USING ' , '

CONDENSE v_base_quantity NO-GAPS.

this will work.

Former Member — Tue, 23 Dec 2008 06:12:06 GMT

please check this code..

FORM check_data TABLES input_table STRUCTURE itcsy

output_table STRUCTURE itcsy .

BREAK-POINT.

READ TABLE input_table WITH KEY name = 'REGUH-RWBTR'.

MOVE input_table-value TO wa_amount. here i got value 1,308,040.00 ,but i want like 1308040.00

CONDENSE wa_amount NO-GAPS.

endform.

Former Member — Tue, 23 Dec 2008 06:28:38 GMT

Hi,

Use

TRANSLATE wa_amount USING ' , '

CONDENSE wa_amount NO-GAPS.

Former Member — Fri, 09 Jan 2009 08:31:04 GMT

ans