topic Replacing comma with space in Application Development and Automation Discussions

topic Replacing comma with space in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345108#M1230992 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Note : I am using SAP 4.6 </P><P></P><P>Task : Replace Comma with space</P><P>Problem : Not able to replace comma with space</P><P></P><P>I have task where I have to write result file to application server, when I am writing string to application server it is separating by comma, for example if you take below statement it is dividing by space that means in first column PO and then ITEM etcu2026.</P><P></P><P>MOVE 'PO ITEM is not there in table EKPO' TO W_RECORD_OUT-ERROR_MSG.</P><P></P><P>so to resolve this situation I have used below code for now, I know I can use </P><P>REPLACE ... ALL ENTRIES but this statement is not working in SAP 4.6</P><P></P><P>REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P></P><P>appreciate if somebody can help me.</P><P></P><P>Thanks</P><P>sarath</P></BODY></HTML> Sun, 15 Mar 2009 15:26:52 GMT Former Member 2009-03-15T15:26:52Z Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345108#M1230992 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Note : I am using SAP 4.6 </P><P></P><P>Task : Replace Comma with space</P><P>Problem : Not able to replace comma with space</P><P></P><P>I have task where I have to write result file to application server, when I am writing string to application server it is separating by comma, for example if you take below statement it is dividing by space that means in first column PO and then ITEM etcu2026.</P><P></P><P>MOVE 'PO ITEM is not there in table EKPO' TO W_RECORD_OUT-ERROR_MSG.</P><P></P><P>so to resolve this situation I have used below code for now, I know I can use </P><P>REPLACE ... ALL ENTRIES but this statement is not working in SAP 4.6</P><P></P><P>REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P> REPLACE ',' WITH ' ' INTO W_RECORD_OUT-ERROR_MSG.</P><P> CONDENSE W_RECORD_OUT-ERROR_MSG.</P><P></P><P>appreciate if somebody can help me.</P><P></P><P>Thanks</P><P>sarath</P></BODY></HTML> Sun, 15 Mar 2009 15:26:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345108#M1230992 Former Member 2009-03-15T15:26:52Z Re: Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345109#M1230993 <HTML><HEAD></HEAD><BODY><P>You can try :</P><P></P><P>Overlay <variable> with <spaces based on length> ONLY ','.</P><P></P><P>Mathews</P></BODY></HTML> Sun, 15 Mar 2009 15:33:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345109#M1230993 Former Member 2009-03-15T15:33:13Z Re: Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345110#M1230994 <HTML><HEAD></HEAD><BODY><P>if w_record_out-error_msg ca ','.</P><P>split w_record_out-error_msg at ',' into lv_string1 </P><P>lv_string2</P><P>contatenate lv_string1 lv_string2 seperated by space.</P><P>endif.</P></BODY></HTML> Sun, 15 Mar 2009 15:54:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345110#M1230994 Former Member 2009-03-15T15:54:07Z Re: Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345111#M1230995 <HTML><HEAD></HEAD><BODY><P>Ur replace statment is fine just dont use ' ' instead use ` ` ( the quotes beside number 1 on top left).</P><P>Then it will work fine.</P><P></P><P><SPAN __default_attr="16" __jive_macro_name="size">кu03B1ятu03B9к</SPAN></P></BODY></HTML> Sun, 15 Mar 2009 16:09:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345111#M1230995 Former Member 2009-03-15T16:09:41Z Re: Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345112#M1230996 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>just see the code below if you feel that its fine then you can proceed with it...</P><P></P><PRE><CODE>REPLACE ',' WITH space INTO W_RECORD_OUT-ERROR_MSG. " Replaced with the keyword space</CODE></PRE><P></P><P>Regards,</P><P>Siddarth</P></BODY></HTML> Sun, 15 Mar 2009 16:28:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345112#M1230996 Former Member 2009-03-15T16:28:11Z Re: Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345113#M1230997 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>replace all occurrences of ','</P><P> in <field> with space . </P><P>Thanks,</P><P>Krishna</P></BODY></HTML> Mon, 16 Mar 2009 02:53:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345113#M1230997 Former Member 2009-03-16T02:53:51Z Re: Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345114#M1230998 <HTML><HEAD></HEAD><BODY><P>Please see: [Inconsistent Behavior of the REPLACE statement|<A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="578006"></A>;</P><P></P><P>Rob</P></BODY></HTML> Mon, 16 Mar 2009 03:18:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345114#M1230998 Former Member 2009-03-16T03:18:24Z Re: Replacing comma with space https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345115#M1230999 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Please check the below code. </P><P></P><PRE><CODE> REPORT YSAT_TEST. Data: Var1(40) type c value 'Test1,Test2,Test3,Test4'. break-point. REPLACE ',' WITH space INTO Var1. " It will replace only first occurrence replace all occurrences of ',' in var1 with ' '. CONDENSE Var1 no-gaps. write: var1.</CODE></PRE><P></P></BODY></HTML> Mon, 16 Mar 2009 03:20:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replacing-comma-with-space/m-p/5345115#M1230999 Former Member 2009-03-16T03:20:09Z