Data filtering and deleting basis tect

GM All   I am looking for a solution where I would like to find specific text in one column that to first occurence as I have multiple values in same column.   Once it identified we need to delet...