Split string into different variables?

[Lsaager]

Hi there,
I have trouble and look for a little help.

After importing some datas from Excel i have a string variable with values
like: 00 2 3 23 555 6777 (numbers and blanks)
Now i want to split this variable in single new variables (the numbers and also
the blanks) for further statistics.
I tried substring and recode but both did not work as i hoped.(could be my
fault as a rookie :)

Anyone who can help me?

Thanks!!!

Leif

[David Futrell]

Lsaager wrote:

You have at least 3 choices. First, you can do this in SPSS with some of the string
commands. Second, if the blanks between the numbers are the delimiters, you might
consider spliting the fields (Text to columns) in Excel before you move it over to
SPSS. Third, you could write the file from Excel to a text file text file and
reading it into SPSS with a DATA LIST statement.

If you're not at all familiar with SPSS syntax, then splitting the fields in Excel
before reading it into SPSS is by far the easiest option.

David Futrell
Indianapolis