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.
0
Best 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
2
Categories
- All categories
- 17 Get started
- 470 Get involved
- 13 Support
- 272 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 218 Community categories