topic Re: remove zeros in Application Development and Automation Discussions

remove zeros

Former Member — Tue, 30 Jan 2007 22:50:28 GMT

Hi all,

I have an internal table in which some fields contain zeros only. i want to remove the zeros, and make the fields blank.

Please help me..

Thanks

Pranati

Re: remove zeros

former_member86837 — Tue, 30 Jan 2007 22:54:18 GMT

If you mean you don't want to write the zeros when you use the WRITE statement then:

WRITE: itab-field1 no-zero.

Re: remove zeros

Former Member — Tue, 30 Jan 2007 22:57:50 GMT

Hi,

You can use SHIFT.

DATA: V_CHAR(10) VALUE '00000'.

SHIFT V_CHAR LEFT DELETING LEADING '0'.

Thanks,

Naren

Re: remove zeros

Former Member — Tue, 30 Jan 2007 23:01:05 GMT

Sorry. Yes its possible with SHIFT. I didnt know that.

May be you can do something like this:

data: begin of itab occurs 0,

a type c,

end of itab.

itab-a = '0'.

append itab.

loop at itab.

shift itab-a left deleting leading '0'.

modify itab.

endloop.

write itab.

Thanks,

Santosh

null

Re: remove zeros

Former Member — Tue, 30 Jan 2007 23:06:42 GMT

Hi Naren,

Thanks for your reply.. it worked. is there any way we can make it work using 'clear' ?

I tried using...

CONSTANTS hex(1) TYPE x VALUE IS INITIAL.

CLEAR f with hex.

but it was giving me syntax error.

Thanks

Pranati.

Re: remove zeros

Former Member — Tue, 30 Jan 2007 23:09:45 GMT

Hi,

Try this..

DATA: V_NUMC(3) TYPE N VALUE '000'.

CLEAR: V_NUMC WITH space.

Thanks,

Naren

Re: remove zeros

Former Member — Tue, 30 Jan 2007 23:10:53 GMT

Yes you can use CLEAR aswell.

itab-a = '000'.

append itab.

loop at itab.

<b> clear itab-a.</b>

modify itab.

endloop .

Thanks,

Santosh

Re: remove zeros

Former Member — Tue, 30 Jan 2007 23:16:04 GMT

Hi all,

problem solved..so i am closing the thread.. thanks everyone for helping me out..

Cheers

Pranati