topic Re: trim all zero in Application Development and Automation Discussions

trim all zero

Former Member — Wed, 12 Mar 2008 19:57:31 GMT

hi, im trying to download an itab into a text file.... using gui download....

the thing is that i have been requested to cut off all the zeros from the fields... but they must still be aligned right like a number....

for example

Material

00001254

00015680

should be

Material

1254

15680

any help will be rewarded

Edited by: JAVIER SALAZAR on Mar 12, 2008 8:57 PM

Former Member — Wed, 12 Mar 2008 20:07:24 GMT

You Can use the following statement:

SHIFT c LEFT DELETING LEADING c1.

eg.,

data : matnr(8) value '00001234'.

write : matnr.

shift matnr left deleting leading '0'.

write : matnr.

Output:

000001234

1234

Reward points if it is useful..

Former Member — Wed, 12 Mar 2008 20:34:12 GMT

You can try:

data: Mat(10) value '0000001254'.
translate mat using '0 '.    "<====  zero to space

Rob

Former Member — Wed, 12 Mar 2008 21:19:07 GMT

i tried both solutions

1. it does the change but doesnt align to the right

2. Does the changes but also deletes zeros from the number....EG wont work for 52060..

help!

Former Member — Wed, 12 Mar 2008 21:28:00 GMT

Well, I'm a bit embarassed. I usually check that sort of thing. So try:

DATA: mat(10) VALUE '0000001054'.
SHIFT mat LEFT DELETING LEADING '0'.
SHIFT mat RIGHT DELETING TRAILING ' '      "<==== space.

Rob