Separate
This dialog separates a variable's values into parts (one variable for each part) based on characters that define the separate parts.
For example, if the character used to separate is a comma (,) , it will separate the values into parts around the commas.
The number of variables added to the dataset will be the maximum number of parts that any observation was separated into. The names of the new variables will be the variable name being separated, plus a numbered suffix that corresponds to each part. The variables will contain missing values if an observation cannot be separated into the maximum number of variables. If the characters used to separate cannot be found in the value, then the original value will be returned (i.e. there is only one part).
Aggregate
Variable to separate:
Specify the variable you want to separate into parts. This can be a character, numeric, factor, ordinal factor, or a date variable. A non-character variable will be coerced to a character variable for the purposes of separating, but the original variable will be left as-is.
Characters used to separate:
Specify the character pattern that is the separator of the parts. This can be one or more characters.