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

rajatdasrajatdas Member Posts: 3 image Learner I
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....

Answers

  • ceaperezceaperez Member Posts: 541 image Unicorn
    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
Sign In or Register to comment.