I'm trying to merge two datasets using the email addresses.

There are a number of observations in the email varlist which are not email addresses (they are redundant bits of text from the export of data from the survey platform).

So I would like to run a command which drops any observation from the email varlist if it does not contain the '@' mark anyway in that observation.

I've been unable to find anything telling me how to drop an observation if it includes a specific character within a longer string (as opposed to equals/is greater than etc.)

Many thanks,
Harry