replace '0' with blank when using XXL_FULL_API function

[former_member382644]

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]

Hi,

try: translate itab using '0 '.

A.

[Former Member]

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]

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]

Hi,

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

Thanks

Wilson