Find and replace exact word

[Monica_]

Hello I am currently working on a project. It has multiple and concatenated statuses. 

I just want to remove all the "hydrated" ones.

Sample status:

1) hydrated, mildly dehydrated, severely dehydrated

2) hydrated

3) mildly dehydrated, hydrated

Output needed:

1) mildly dehydrated, severely dehydrated

2) 

3) mildly dehydrated

I used replacechar however it is not looking for the exact word. Also used regex_replace but same wrong results.

Any ideas? Thanks!

[ShankerV]

Hi @Monica_ 

You can use Find and Replace tool or Formula tool to get your solution.

Many thanks

Shanker V

[Monica_]

Hello, still not working on my end 

[ShankerV · Accepted solution]

Hi @Monica_ 

Please check the solution, hope it helps

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Monica_]

Worked well. Thanks!

[ShankerV · Accepted solution]

Hi @Monica_ 

With the help of Data Cleansing tools, have also trimmed the unwanted spaces and the output expected is as below.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Monica_]

Thanks, @ShankerV  😁