remove specific words from the sentence

[Kuldeepmathur]

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

[Felipe_Ribeir0 · Accepted solution]

Hi @Kuldeepmathur 

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.

[atcodedog05]

Hi @Kuldeepmathur 

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 : )