topic Re: Replace: problem with zeros in Application Development and Automation Discussions

Replace: problem with zeros

Former Member — Sat, 14 Nov 2009 16:58:54 GMT

Hi to everybody

I have tihs values

31.800

0.300

2.100

I should to get this

31,800

00,300

02,100

I use REPLACE ALL OCCURRENCES OF '.' IN lt_itob-id1 WITH ',' it is ok

but I get an error if I use REPLACE ALL OCCURRENCES OF space IN lt_itob-id1 WITH '0' .

Could you help me?

Thanks a loto

Re: Replace: problem with zeros

Former Member — Sat, 14 Nov 2009 17:12:56 GMT

For pdding zeros in the begning use the following:

SHIFT RIGHT <variable> RIGHT DELETING TRAILING SPACE.

And for replacing '.' with ',', i think you will ahve to make use of IF loop and do this operation withn it.

Regards

Gaurav

Re: Replace: problem with zeros

kesavadas_thekkillath — Sat, 14 Nov 2009 17:19:27 GMT

Please be more clear .

Re: Replace: problem with zeros

Former Member — Sat, 14 Nov 2009 17:26:37 GMT

Hi,

I think you can use SHIFT statement as suggested. Press F1 on SHIFT.

Re: Replace: problem with zeros

Clemenss — Sat, 14 Nov 2009 18:41:56 GMT

Hi Georgio,

unable to answer incomplete questions: ID1 is no field of DB view ITOB. Thus you should give the field technical settings here.

Post a few code lines on how you populate the field (Don't worry, CIA knows anyway)..

Then someone can answer your question.

Regards,

Clemens

Re: Replace: problem with zeros

Former Member — Mon, 16 Nov 2009 06:37:50 GMT

Hi ,

if the pattern of the variable in which u r taking value is constant,i.e if there are 3 values after decimal as shown in below code ,you can use below code.

DATA : l_local(6) TYPE c.

l_local = '0.300'.

concatenate '0' l_local into l_local.

REPLACE ALL OCCURRENCES OF '.' IN l_local WITH ',' .

Edited By

Tejaswini Khante

Re: Replace: problem with zeros

Former Member — Mon, 16 Nov 2009 07:17:47 GMT

Hi,

To Replace space with '0' use OVERLAY statement.


DATA: l_val TYPE char6 VALUE '0.300'.

REPLACE ALL OCCURRENCES OF '.' IN l_val WITH ',' .
SHIFT l_val RIGHT DELETING TRAILING space.

OVERLAY l_val WITH '000000'.
WRITE l_val.

Regards,

Farheen