Function for similar characters

Hello, I would like to create a function that will show as "false" when a column (E.g. consumers first name) has multiple of the same characters in a row.

'John' or 'Matt' would be pass, while 'Samuuuel' or 'Mattt' would be the fails.

I was able to create one using the "substring" and "in length range" functions but this only looks at the first 3 characters.

Best Answer

  • Henry SimmsHenry Simms Experian Super Contributor
    Answer ✓

    Hi @Juan_NFCU - Take a look at the Repeating Characters function that's been shared in the Functions Library. There are a couple of versions of the function there, all based on regex pattern matching, but you probably want to try the latest one created by @Fatme Kungyova

Sign In or Register to comment.