topic Re: replace '0' with blank when using XXL_FULL_API function in Application Development and Automation Discussions

replace '0' with blank when using XXL_FULL_API function

former_member382644 — Fri, 26 May 2006 04:34:35 GMT

Hi,

Can the '0' value be replaced by blank when using XXL_FULL_API to export data to excel ?

e.g.

internal table

Col_Str Col_num

abc 0

excel

Col_Str Col_num

abc

Thanks

Wilson

andreas_mann3 — Fri, 26 May 2006 09:38:56 GMT

Hi,

try: translate itab using '0 '.

Former Member — Fri, 26 May 2006 09:45:49 GMT

use this logic to replace 0 with space and than pass internal table ......

DATA : BEGIN OF itab OCCURS 0,

str(50),

END OF itab.

DATA : cha(50) VALUE 'kishan0singh0negi',

str(2000).

SPLIT cha AT '0' INTO TABLE itab.

loop at itab.

concatenate str itab-str into str separated by space.

endloop.

write : str.

Former Member — Fri, 26 May 2006 09:50:06 GMT

loop at itab.

replace '0' with ` ` in itab-col_num.

modify itab.

endloop.

<b>note that the quotes are not the normal quotes but the key above the 'Tab' key in the keyborad.</b>

Regards,

Ravi

former_member382644 — Sat, 27 May 2006 14:25:18 GMT

Hi,

it is alrady done by using char type in a new internal table.

Thanks

Wilson