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!
Solved! Go to Solution.
Hi @Monica_
You can use Find and Replace tool or Formula tool to get your solution.
Many thanks
Shanker V
Hello, still not working on my end
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
Worked well. Thanks!
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
Thanks, @ShankerV 😁