How to do "text to column" on an excel dataset in Rapidminer ?
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....
Something like:
text1, text2, text 3 to be converted into Column A for text1, Column B for text2 and Column C for text3....
0
Learner I
Answers
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