🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"split values of column into new column"

User: "Friso"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with

Sort by:
1 - 1 of 11
    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