=========================================================================
Date:         Tue, 11 Jul 2006 16:35:39 -0400
Reply-To:     Monica Perry <mperry@pitt.k12.nc.us>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Monica Perry <mperry@pitt.k12.nc.us>
Subject:      reverse concat
Content-Type: text/plain; charset=US-ASCII

Hello List,

I need to remove dashes from social security numbers, and I'm having
some trouble.

To put them in  I use the concat function in the compute dialog box:

SSnumD=concat(substr(SSnum,1,3),'-',substr(SSnum,4,2),'-',substr(SSnum,6,4))

I tried taking the dash out of the '-' parts; leaving it blank the
first time, like this --> ' '
and removing the space the second time, like this -->  ''

I figured it would read as "From position 1 go 3 spaces, enter nothing,
From position 4 go 2 spaces, enter nothing" (instead of reading ' enter
dash')

Is there such a thing as unconcatenate?

Any tips would be appreciated.
Thanks, Monica

Monica Perry
Title 1 Program Specialist
Pitt County Schools, Greenville NC