I have junk email in this email list, and its close to 30,000 emails. About 1,000 plus emails have punctuation by mistake in front. I know I can remove punctuation from an email by using Data Cleansing Tool, but that would also remove '@', which I don't want to remove. Also, some emails have punctuation as part of their regular email in the middle.
Example:
?rsmith@gmail.com
-mike.harold@google.com
Any ideas?
Solved! Go to Solution.
I might look to see what characters you dislike
Replacechar([email],"'!?,&$)(;:/[]{}#%^*+=\|~<>€£¥",'')
cheers,
mark