Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

excel problem

Former Member

‎2007 Nov 10 7:57 AM

0 Likes
351

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.

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.

Reply
1 REPLY 1
Read only

Former Member

‎2007 Nov 10 10:01 AM

0 Likes
311

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