2009 Dec 22 9:32 AM
Does anybody know how to replace an ' with space.
I need the word 'Jon' to be converted into Jon .
Thanx
2009 Dec 22 9:37 AM
Hi,
Did you mean something like
REPLACE ',' IN W_DATA WITH SPACE.
?
2009 Dec 22 9:35 AM
Hello
REPLACE '''' WITH space INTO field.
2009 Dec 22 9:40 AM
We can do like this also.
replace `'` in myvar with ''.
we can use tilde character / key. it is found on keyboard to the left of '1' key.
regards,
amit m.
2009 Dec 22 9:58 AM
yes. the one whch Amit had suggested is the right one.
You can try.
2009 Dec 22 10:02 AM
Please use the syntax : REPLACE ',' IN W_DATA WITH SPACE.
Vivek Gupta
2009 Dec 22 11:15 AM
Yes, it is useful to using ` character in string operations. You can use `'` easily as an alternative.
Bluesky
