The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 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 Newbie
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....


  • Options
    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. 

Sign In or Register to comment.