| Date: | Thu, 28 Jun 2007 21:32:04 -0400 |
|---|
| Reply-To: | Richard Ristow <wrristow@mindspring.com> |
|---|
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
|---|
| From: | Richard Ristow <wrristow@mindspring.com> |
|---|
| Subject: | Re: How to Replace a single quote |
|---|
|
| In-Reply-To: | <888374.57022.qm@web62008.mail.re1.yahoo.com> |
|---|
| 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,
Richard
|
