topic Re: DELETE ZERO BEFORE NUMBER in Application Development and Automation Discussions

DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:22:38 GMT

hallow

i have field type numc20 and i wont to delete all zero before num

how can i do that

example

i have

000000000317

i wont 317

REGARDS

Re: DELETE ZERO BEFORE NUMBER

dev_parbutteea — Tue, 12 Jun 2007 10:25:38 GMT

Hi,

use FM : CONVERSION_EXIT_ALPHA_OUTPUT

Regards,

Sooness

Re: DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:27:32 GMT

Hi Shnya ,

Use the shift command.

Here is a sample code for the same

data : test(20) type n.

test = '000000000317'.
write / test.
shift test  left deleting leading '0'..

write / test.

Hope this helps

Regards

Arun

Re: DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:28:31 GMT

Hi,

You can use Condense number.

this will truncate the leading zeroes.

truncate numc.

Regards

Shiva

Re: DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:29:31 GMT

hi,

CONVERSION_EXIT_ALPHA_OUTPUT is the Fm used for giving desired o/p and takes a input from user

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

input = int [int is avaraible of type num20

IMPORTING
OUTPUT = k. [ resultant value by FM]

if useful reward some points.

with regards,

suresh.

Re: DELETE ZERO BEFORE NUMBER

anversha_s — Tue, 12 Jun 2007 10:29:40 GMT

hi,

data : v_matnr(40) type c,
       v_mat type matnr.
 
v_mat = '00000123456789'.
 
       pack v_mat to v_matnr.
 
write v_matnr.

Rgds

Anversha

Re: DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:30:00 GMT

you can try this also..

REPORT ychatest MESSAGE-ID zz..

DATA : v_char(20) VALUE '000000000317'.

TRANSLATE v_char USING '0 '.
CONDENSE v_char NO-GAPS.
WRITE : v_char.

Re: DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:31:56 GMT

also check this

DATA : v_char(20) VALUE '000000000317'.

WRITE : v_char TO v_char NO-ZERO.
condense v_char no-gaps.
WRITE : v_char.

Re: DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:36:51 GMT

This is not the better way, but is quick !!

PACK field INTO field.

Re: DELETE ZERO BEFORE NUMBER

Former Member — Tue, 12 Jun 2007 10:44:59 GMT

hi,

<b>u follow this logic..</b>

WRITE: '000123',

/ '000123' NO-ZERO.

u can get output like this..

000123

123

regards,

Ashokreddy.