topic Re: replace ' with space in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503700#M1422220 <HTML><HEAD></HEAD><BODY><P>Please use the syntax : REPLACE ',' IN W_DATA WITH SPACE.</P><P></P><P>Vivek Gupta</P></BODY></HTML> Tue, 22 Dec 2009 10:02:07 GMT VivekG 2009-12-22T10:02:07Z replace ' with space https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503695#M1422215 <HTML><HEAD></HEAD><BODY><P>Does anybody know how to replace an ' with space. </P><P>I need the word 'Jon' to be converted into Jon .</P><P>Thanx</P></BODY></HTML> Tue, 22 Dec 2009 09:32:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503695#M1422215 Former Member 2009-12-22T09:32:55Z Re: replace ' with space https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503696#M1422216 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><PRE><CODE> REPLACE '''' WITH space INTO field. </CODE></PRE><P></P></BODY></HTML> Tue, 22 Dec 2009 09:35:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503696#M1422216 Former Member 2009-12-22T09:35:38Z Re: replace ' with space https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503697#M1422217 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Did you mean something like</P><P></P><P>REPLACE ',' IN W_DATA WITH SPACE.</P><P></P><P>?</P></BODY></HTML> Tue, 22 Dec 2009 09:37:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503697#M1422217 Former Member 2009-12-22T09:37:58Z Re: replace ' with space https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503698#M1422218 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We can do like this also.</P><P></P><PRE><CODE> replace `'` in myvar with ''. </CODE></PRE><P></P><P></P><P>we can use tilde character / key. it is found on keyboard to the left of '1' key.</P><P></P><P>regards,</P><P>amit m.</P></BODY></HTML> Tue, 22 Dec 2009 09:40:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503698#M1422218 Former Member 2009-12-22T09:40:01Z Re: replace ' with space https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503699#M1422219 <HTML><HEAD></HEAD><BODY><P>yes. the one whch Amit had suggested is the right one.</P><P></P><P>You can try.</P></BODY></HTML> Tue, 22 Dec 2009 09:58:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503699#M1422219 former_member778253 2009-12-22T09:58:32Z Re: replace ' with space https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503700#M1422220 <HTML><HEAD></HEAD><BODY><P>Please use the syntax : REPLACE ',' IN W_DATA WITH SPACE.</P><P></P><P>Vivek Gupta</P></BODY></HTML> Tue, 22 Dec 2009 10:02:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503700#M1422220 VivekG 2009-12-22T10:02:07Z Re: replace ' with space https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503701#M1422221 <HTML><HEAD></HEAD><BODY><P>Yes, it is useful to using ` character in string operations. You can use `'` easily as an alternative.</P></BODY></HTML> Tue, 22 Dec 2009 11:15:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/replace-with-space/m-p/6503701#M1422221 Former Member 2009-12-22T11:15:00Z