"split values of column into new column"

Friso

Hi,
would I would like be able to split certain values in a column and put these values in a new column. I.e:

|"Cognome"|"Nome"|"Via_completa"|"Civico"|"Esponente"|"CAP"|"Frazione"|"Comune"|"Provincia"
|"ACCROCCA"|"ALESSIO"|"VIA NAPOLI"|"83"||"00055"||"LADISPOLI"|"RM"

The "Via_completa"column is made out of the values 'VIA' and 'NAPOLI'. To normalize the address according to my data set I would like to split the values 'VIA' and 'NAPOLI' in the column "Via_completa" and create a new column called 'DUG' and place value 'VIA' in the new column.
Like this:

"Cognome"|"Nome"|"DUG"|"Via_completa"|"Civico"|"Esponente"|"CAP"|"Frazione"|"Comune"|"Provincia"
|"ACCROCCA"|"ALESSIO"|"VIA"|"NAPOLI"|"83"||"00055"||"LADISPOLI"|"RM"

In Excel there is a 'Split text among columns' function. Is there a similar operator in Rapid miner to execute this function?
Thanks,
Friso

MartinLiebig

Hi,

If you read this as .CSV you can directly do the split using a regular expression. Otherwise the split operator is the way to go.


Best,
Martin