Currently CPS does not apply a policy to validate email addresses, which allows many staff to enter 'none', 'refused' or other notes in this field.
We would like to blank out only the email field in the outgoing files if it does not contain a @ in the text of the field.
The email appears to be in PID-13.4, so need to ensure that we protect the phone number in PID-13.1
Ultimately to take the invalid email (not containing @ in the field), 'None' in example above, and removing it to be blank. while preserving the Mobile Phone folowing if it exists.