Repeating letters

Question

Hi,

I'm struggling with a file of email addresses to clean up.

I come across fake emails where a letter can be repeated many times such as :

xxx@gmail.com
yyyidmcho@naver.com
xx.xxx@gmail.com
XXX@XXX
avaxxxava@gmail.com
xxxxx.yyyyy@hotmail.fr
xxxprettyboy@naver.com
lucaslucasxxx94@gmail.com

could you please help me with a regular expression to search all the emails with any letter repeated more than twice?

thank you

Luke_C · Accepted Answer

Hi @Esmeralda_In_Paris

Here's an alternative:

* Add unique record IDs
* tokenize to rows
* Multirow formula to count consecutive characters for a given record ID
* Filter to instances where consecutive = 2 (count starts at 0 so 2 indicates at least 3 consecutive characters)
* Group by Record ID
* Join back to the original data to get the population of emails with an issue.