Deleting Rows if it does not contain certain keyword


I am trying to filter an excel file, so that it deletes all rows not containing certain keywords (a date).
So far, I have not figured out a way to do this yet.

Is there anyone that could help?

Kind regards,


Welcome to the UIpath Community.

Use Filter dataTable Activity or use DataTable.Select query to filter the data and will give you output as dataTable. Then write this output into new sheet using Write Range Activity and delete existing sheet.


Been struggling with this all day, you solved it in 5 minutes haha Thanks!


Hey Mike glad to see your question was answered, can you please mark as solved please :white_check_mark:

1 Like


Thanks :grinning:
Could you please close this thread by marking correct post as solution.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.