I thought this might be the case, in the example data you have an example of 'Good night1' that it looked like you wanted to drop as it was not in the result table. It is going to be difficult to work out what to drop and what to look at when you have 'Apple85c(d)' as an actual result. Do all of the values that's you want to keep that contain numbers and letters have a letter within the parentheses?

Might be worth providing some more extensive sample data and expected results within a spreadsheet to get a comprehensive answer.

Hope this helps