🥳 RAPIDMINER 9.9 IS OUT!!! 🥳

The updates in 9.9 power advanced use cases and offer productivity enhancements for users who prefer to code.

CLICK HERE TO DOWNLOAD

Removing a word from list of words

AnushaAnusha Member Posts: 3 Contributor I
Hello All!
a dataset has 2 columns, one column has a list of words, I want to remove the last word including special characters(in this eg,   [,.?]) is it possible?

Source data:
reg_no      text
1               In,a,data,base,,,
2               at,palace,he,has,?,????,

required data:
reg_no     text
1              In,a,data
2              at,palace,he

Best Answer

  • kaymankayman Member Posts: 606   Unicorn
    edited April 6 Solution Accepted
    @Anusha, use regex. 
    The idea is that you want to keep everything till the last comma followed by a word. 

    ^(.*),\w+.*
    
    Not fully tested but it should do the trick.
    use the replace operator with above snippet, and replace with $1 

    You can play with the regex here : 

    https://regex101.com/r/URTvjo/1
    Anusha
Sign In or Register to comment.