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

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!

Regex

Tips and Tricks

Accepted answers

ShankerV

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

Find and replace.yxmd

ShankerV

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

Find and replace.yxmd

All comments

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

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

Find and replace.yxmd

Monica_

Worked well. Thanks!

ShankerV

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

Find and replace.yxmd

Monica_

Thanks, @ShankerV 😁

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335