Answers.Body: <p>Using SearchKit -</p>
  <p>To filter on first name &gt; 12 characters -
  First Name - Matches Pattern - ^[a-z]{12,}</p>
  <p><a href="https://i.sstatic.net/fXJJq26t.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/fXJJq26t.png" alt="enter image description here" /></a></p>
  <p>Ref - <a href="https://stackoverflow.com/questions/1649435/regular-expression-to-limit-number-of-characters-to-10">https://stackoverflow.com/questions/1649435/regular-expression-to-limit-number-of-characters-to-10</a></p>
  <p>Or this one may also be useful, find contacts with more than 1 uppercase letter in their first name -
  First Name - Matches Pattern (case sensitive) - [A-Z].*[A-Z]</p>
  <p><a href="https://i.sstatic.net/DwSmbd4E.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/DwSmbd4E.png" alt="enter image description here" /></a></p>
  <p>Ref - <a href="https://stackoverflow.com/questions/21900903/regex-to-detect-a-word-with-more-than-1-capital-letters">https://stackoverflow.com/questions/21900903/regex-to-detect-a-word-with-more-than-1-capital-letters</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-21T11:03:41.783Z
Answers.LastActivityDate: 2024-05-21T11:03:41.783Z
Answers.UserDisplayName: Anil
Body: <p>I am trying to run a search that would return first names that are random string of letters/numbers. We had a lot of spam come through a signup form, where first names look like &quot;sldkfmVUnkdUnnns&quot; or any other random string of letters. I was hoping I can use search kit to find first names that are longer than normal? I tried to use &quot;matches pattern&quot; but I'm not sure what to do.</p>
  <p>Does anyone have a good solution for finding these spam records?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-05-21T20:13:47.753Z
Comments.Text: interesting solution in those answers. spam also often comes with 'first = last' just in case that has affected you and gives you a/ another way to find delete, b/ another tool to add to your forms to prevent these.
Comments.UserDisplayName: petednz - fuzion
Tags: <searchkit>
Title: Search Kit Match pattern
ThreadText: # Search Kit Match pattern
  
  (Asked by: username_0 on 2024-05-21)
  
  I am trying to run a search that would return first names that are random string of letters/numbers. We had a lot of spam come through a signup form, where first names look like "sldkfmVUnkdUnnns" or any other random string of letters. I was hoping I can use search kit to find first names that are longer than normal? I tried to use "matches pattern" but I'm not sure what to do.
  
  Does anyone have a good solution for finding these spam records?
  
  **Tags:** searchkit
  
  > **Comments:**
  > **username_1**: interesting solution in those answers. spam also often comes with 'first = last' just in case that has affected you and gives you a/ another way to find delete, b/ another tool to add to your forms to prevent these.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2024-05-21. Score: 3 | Accepted answer
  
  Using SearchKit -
  
  To filter on first name > 12 characters -
  First Name - Matches Pattern - ^[a-z]{12,}
  
  [![enter image description here](https://i.sstatic.net/fXJJq26t.png)](https://i.sstatic.net/fXJJq26t.png)
  
  Ref - <https://stackoverflow.com/questions/1649435/regular-expression-to-limit-number-of-characters-to-10>
  
  Or this one may also be useful, find contacts with more than 1 uppercase letter in their first name -
  First Name - Matches Pattern (case sensitive) - [A-Z].\*[A-Z]
  
  [![enter image description here](https://i.sstatic.net/DwSmbd4E.png)](https://i.sstatic.net/DwSmbd4E.png)
  
  Ref - <https://stackoverflow.com/questions/21900903/regex-to-detect-a-word-with-more-than-1-capital-letters>
  
  
  ---
  
  