Date:         Fri, 21 May 2004 17:44:16 +0100
Reply-To:     Paul Mcgeoghan <Mcgeoghan@Cardiff.ac.uk>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Paul Mcgeoghan <Mcgeoghan@Cardiff.ac.uk>
Subject:      string manipulation
Content-Type: text/plain; charset=US-ASCII

Hi,

I have a string variable which may have / appearing in various positions.

I want to create new string variables extracting the data before each slash
into separate variables. Also, I want a count of the number of variables created
with data for each case.

So, if I have data like the following in a variable named Leadman

AB/ABC/ABCD
ABC/FE

I would like
Lead1    Lead2     Lead3   NumLead
AB          ABC       ABCD     3
ABC        FE                       2

How can I do the above?

Thanks in advance,
Paul