topic Re: Append space when the value is 0 in Application Development and Automation Discussions

Append space when the value is 0

Former Member — Thu, 12 Oct 2006 05:42:46 GMT

Hi,

I need to pass space if the field value is '0'. I have field which returns '00000000' in the output. For this i need to pass space. I tried many ways to pass space to this field. But its displaying as '00000000' only. How to pass space to this field. In database the field value is displayed as 0.

Regards,

Ram

Re: Append space when the value is 0

anversha_s — Thu, 12 Oct 2006 05:48:20 GMT

hi ram,

suppose char1 = '000001'.

do this.

REPLACE all occurances of '0' in char1 WITH space INTO char2.

char2 ='1'.

rgds

anver

if helped pls mark points

Message was edited by: Anversha s

Re: Append space when the value is 0

Former Member — Thu, 12 Oct 2006 05:54:52 GMT

Use "REPLACE" statement

Re: Append space when the value is 0

Former Member — Thu, 12 Oct 2006 05:55:11 GMT

in case of ALV,

fcat-no_zero = 'X'.

in case of normal report

write: repid no-zero.

regards

Prabhu

Re: Append space when the value is 0

Former Member — Thu, 12 Oct 2006 05:56:33 GMT

Hi Ram,

You can also use 'CONVERSION_EXIT_ALPHA_OUTPUT'...suppose the input is '0001' then the output will be '1'.

Thanks...

Preetham S

Re: Append space when the value is 0

Former Member — Thu, 12 Oct 2006 05:58:05 GMT

Please try if it works this way...

<b>replace all occurrences of '0' in <fld> with ' '.</b>

Kind Regards

Eswar

Re: Append space when the value is 0

jayanthi_jayaraman — Thu, 12 Oct 2006 06:00:01 GMT

Hi,

Here is the sample code.Try this,it will output space.

data c1(10) value '00000'.

pack c1 to c1.

replace '0' with space into c1.

write c1.

Re: Append space when the value is 0

Former Member — Thu, 12 Oct 2006 06:08:55 GMT

Donot use replace,because when ever the value is '00100' the o/p will be 1.

Instead use this syntax

SHIFT value LEFT DELETING LEADING '0'.

Regards,

Dharani.