The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

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