How to do "text to column" on an excel dataset in Rapidminer ?

rajatdas

On a text variable in excel..which contains multiple values in text format separated by a comma (similar to a CSV file format), I need to segregate the values into separate columns for each value.

Something like:

text1, text2, text 3 to be converted into Column A for text1, Column B for text2 and Column C for text3....

Caperez

Hi @rajatdas,
you can use the Split operator and regular expression for that.
Other alternative is to use the Tokenize operator from text processing extenssion. 

Best, 
Cesar