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

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

Answers

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

    Best, 
    Cesar
Sign In or Register to comment.