topic Re: excel problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/excel-problem/m-p/3007019#M710530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the following code:</P><P></P><P> LOOP AT itab INTO wa_itab. "#EC CI_LOOP_INTO_WA</P><P></P><P> gv_tabix = sy-tabix.</P><P></P><P> DO.</P><P> IF wa_itab CA '"'.</P><P> REPLACE '"' WITH space INTO wa_itab.</P><P> ELSE.</P><P> WRITE wa_itab TO wa_itab NO-GAP.</P><P> CONDENSE wa_itab.</P><P> MODIFY itab INDEX gv_tabix FROM wa_itab.</P><P> EXIT.</P><P> ENDIF.</P><P> ENDDO.</P><P> ENDLOOP.</P><P></P><P>Regards</P><P>Kannaiah</P></BODY></HTML> Sat, 10 Nov 2007 10:01:36 GMT Former Member 2007-11-10T10:01:36Z excel problem https://community.sap.com/t5/application-development-and-automation-discussions/excel-problem/m-p/3007018#M710529 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>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.</P><P>can anybody tell me how to do it.</P><P>points would be rewarded to all.</P><P>rgds.</P></BODY></HTML> Sat, 10 Nov 2007 07:57:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-problem/m-p/3007018#M710529 Former Member 2007-11-10T07:57:29Z Re: excel problem https://community.sap.com/t5/application-development-and-automation-discussions/excel-problem/m-p/3007019#M710530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the following code:</P><P></P><P> LOOP AT itab INTO wa_itab. "#EC CI_LOOP_INTO_WA</P><P></P><P> gv_tabix = sy-tabix.</P><P></P><P> DO.</P><P> IF wa_itab CA '"'.</P><P> REPLACE '"' WITH space INTO wa_itab.</P><P> ELSE.</P><P> WRITE wa_itab TO wa_itab NO-GAP.</P><P> CONDENSE wa_itab.</P><P> MODIFY itab INDEX gv_tabix FROM wa_itab.</P><P> EXIT.</P><P> ENDIF.</P><P> ENDDO.</P><P> ENDLOOP.</P><P></P><P>Regards</P><P>Kannaiah</P></BODY></HTML> Sat, 10 Nov 2007 10:01:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-problem/m-p/3007019#M710530 Former Member 2007-11-10T10:01:36Z