|Date: ||Thu, 28 Jun 2007 21:32:04 -0400|
|Reply-To: ||Richard Ristow <firstname.lastname@example.org>|
|Sender: ||"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>|
|From: ||Richard Ristow <email@example.com>|
|Subject: ||Re: How to Replace a single quote|
|Content-Type: ||text/plain; charset="us-ascii"; format=flowed|
At 08:37 PM 6/28/2007, Ty Noonan wrote:
>Is there a way to remove a single quote ' from string data. SPSS does
>not seem to like single quotes in the replace function.
Are you running into the problem of declaring a constant whose value is
a single quote? Not tested, but
COMPUTE <target> = REPLACE(<source>,"'",<replacement>).
should work. If it doesn't, maybe re-post, with the syntax you're
using, test data, any error or warning messages, and what you hoped for
vs. what you got.
-Very good luck,