Regex for repeating characters

spaul30

I am trying to find regex for 2 types of situations:

1. where string has letters repeating 3 times in the beginning like aaatgre, rrryutu, yyyuiop,www-retdfdf etc

2. where string has letters repeating 3 times in the end like rtyuiii, tyrdyyy, iioottqqq etc.

Can someone help me in building the regex for these two scenarios. Thanks !

Tips and Tricks

Accepted answers

CharlieS

Here's a not-so-RegEx method for this:

The only difference is if the Tile tool sorts the values first (so the original sequence doesn't matter) or not.

20190329-RepeatingChars.yxmd

CharlieS

I'm glad that worked.

To get the last 3 characters: use the same method you did on the first 3 but on a reversed string using this function first: ReverseString(

All comments

CharlieS

Here's a not-so-RegEx method for this:

The only difference is if the Tile tool sorts the values first (so the original sequence doesn't matter) or not.

20190329-RepeatingChars.yxmd

spaul30

yes this solves the problem. Also i am looking for repeating characters in the first 3 and last 3 characters in a string. I was able to get the first 3 characters using Substring function. How to extract the last 3 characters of the string?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703