Extract specific digits pattern

[wtahir]

Hi all,

I am struggling to come up with an optimal way of extracting some pattern of digits. I know that regex should definitely have an answer but I do not know how to do it. I have a single column data in the following format:

Field

01234

012345

1234567

I want to extract if an entry is composed of same digits i.e. "1111", "222222", "1111111" and so on....the length of digits can range from 5-10. Any ideas? A help would be much appreciated. Thank you

[wdavis · Accepted solution]

Hi @wtahir 

I have built a workflow which hopefully gets to what you are after.

A combination of the Regex, Multi-Row Formulas and Summarize should create the pattern for you.

Let me know if you have any questions!

Kind Regards,

Will

[Qiu · Accepted solution]

@wtahir 
I have two approaches for you. 

[wtahir]

Thank you @wdavis and @Qiu for the answers. Your solutions work like charm. Thank you for helping me out.