Remove Rows with Specific Words

[mustufa2019]

From the name column, I am trying to remove all rows that start with "MDL:", "TELLY", and end with "SEI". Is there a function to perform this? See below screenshot and yellow highlighted words

[JoeS · Accepted solution]

Hi @mustufa2019 

You will want to use the filter tool and write the conditions needed.

I like to use one filter for each condition as I find that easier to interpret in 6 months time when I come back to a workflow to remember what I have done.

So the conditions would be:

Filter 1:

!StartsWith([Name],"MDL:")
AND
!StartsWith([Name],"TELLY")

Filter 2:

!EndsWith([Name], "SEI")

Like the attached:

[Jonathan-Sherman]

I would agree with the solution @JoeS has provided but would also like to add one thing in. The reason we would use more than one filter rather than combining all conditions into one tool is for (run time) efficiency savings.

If the first filter removes 20% records the second filter only needs to perform its condition on the remaining 80% and so on, therefore less processing needs to take place. The efficiency savings on a smaller data set would be minimal but increase with the size of the data set. Worth thinking about for future workflows.

[mustufa2019]

@JoeS This was perfect! thank you so much!

[JoeS]

---

@mustufa2019 wrote:

@JoeS This was perfect! thank you so much!

---

You're welcome. Glad I was able to help.

[Teckydoo2]

This was a great help for me also.