A way to filter gibberish Emails and Usernames

KumaMatata 

Identifying gibberish or fake accounts based on patterns in email names or usernames can be challenging, as there are countless variations. However, you can use some Excel functions and formulas to create a set of rules that might help in flagging potential gibberish.

Here is a basic example to get you started:

Let's assume your email addresses are in column A, and usernames are in column B. You can add a new column (let's say column C) with a formula to check for patterns. Use the following formula in cell C2 and drag it down:

=IF(AND(ISNUMBER(SEARCH("^[A-Za-z]{3,}[0-9]{4,}$", A2)), ISNUMBER(SEARCH("^[A-Za-z]{2,}[0-9]{4,}$", B2))), "Potential Gibberish", "Normal")

This formula checks if both the email and username follow a pattern of starting with letters and ending with numbers. You might need to adjust these patterns based on the specific characteristics of the accounts you consider gibberish.

Explanation of the formula:

• SEARCH("^[A-Za-z]{3,}[0-9]{4,}$", A2): Checks if the email starts with at least 3 letters and ends with at least 4 numbers.
• SEARCH("^[A-Za-z]{2,}[0-9]{4,}$", B2): Checks if the username starts with at least 2 letters and ends with at least 4 numbers.
• AND(ISNUMBER(...), ISNUMBER(...)): Checks if both conditions are true.
• If both conditions are true, it returns "Potential Gibberish"; otherwise, it returns "Normal".

Feel free to adjust the patterns in the SEARCH functions based on your observations of gibberish accounts. This is just a starting point, and you may need to refine the criteria based on the specific characteristics of the accounts you encounter. The text was revised with the AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.