Removing a word from list of words
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
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
Find more posts tagged with
Sort by:
1 - 1 of
11
Sort by:
1 - 1 of
11
@Anusha, use regex.
The idea is that you want to keep everything till the last comma followed by a word.
use the replace operator with above snippet, and replace with $1
You can play with the regex here :
https://regex101.com/r/URTvjo/1
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
The idea is that you want to keep everything till the last comma followed by a word.
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