excel problem

[Former Member]

hi all,

iam downloading data for material master fromold sap system into excel. but whereever there are inverted commas i get garbage value in excel due to which some material records alsogets missed.

can anybody tell me how to do it.

points would be rewarded to all.

rgds.

[Former Member]

Hi,

Check the following code:

LOOP AT itab INTO wa_itab. "#EC CI_LOOP_INTO_WA

gv_tabix = sy-tabix.

DO.

IF wa_itab CA '"'.

REPLACE '"' WITH space INTO wa_itab.

ELSE.

WRITE wa_itab TO wa_itab NO-GAP.

CONDENSE wa_itab.

MODIFY itab INDEX gv_tabix FROM wa_itab.

EXIT.

ENDIF.

ENDDO.

ENDLOOP.

Regards

Kannaiah