LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2006)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
=========================================================================
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


Back to: Top of message | Previous page | Main SPSSX-L page