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

rajatdas
rajatdas New Altair Community Member
edited November 5 in Community Q&A
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....
Tagged:

Answers

  • Caperez
    Caperez Altair Community Member
    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

Categories