HI,
I am trying to find and remove the Dr. Name from the data.
MY health is great due to dr. ravi as he is great
I am struggling because of dr. kuldeep is not good
output expected :
MY health is great due to dr. as he is great
I am struggling because of dr. is not good
Thanks,
Kuldeep
Solved! Go to Solution.
Here is one way of doing that
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.
Here is a way of doing it.
Workflow:
the string we are trying to find is dr. name
(dr\.) captures dr.
(\u+) captures letters
REGEX_Replace([phrase], "(dr\.) (\u+)", "$1") replaces dr. name it with only dr.
Hope this helps : )