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

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

Extract Digit Pattern.yxmd