topic Function to convert 0 to space in Application Development and Automation Discussions

Function to convert 0 to space

Former Member — Mon, 18 Sep 2006 10:07:16 GMT

Is there any function to convert 0 to spaces or something similar?

Thank you in advance.

Former Member — Mon, 18 Sep 2006 10:10:27 GMT

How about this???

REPLACE ALL OCCURRENCES OF '0' IN L_TEXT WITH SPACE.

SHIFT L_TEXT LEFT DELETING LEADING '0'.

Kind Regards

Eswar

Former Member — Mon, 18 Sep 2006 10:12:50 GMT

Hi,

use

SHIFT c LEFT DELETING LEADING c1.

SHIFT c RIGHT DELETING TRAILING c1.

shift var left removing leading '0'.

shift var right removing trailing '0'.

Regards

Amole

anversha_s — Mon, 18 Sep 2006 10:16:45 GMT

hi,

chk this exmaple.

data: l_amnt(100) type c.

l_amnt = ' 1.234.567,89'.

replace all occurrences of ',' in l_amnt with '#'.

replace all occurrences of '.' in l_amnt with ','.

replace all occurrences of '#' in l_amnt with '.'.

replace all occurrences of ' ' in l_amnt with ' 0'.

write : l_amnt.

rgds

anver

if helped mark points