Removing a word from list of words

Anusha

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

kayman

@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

kayman

@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