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
Solved! Go to 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
@wtahir
I have two approaches for you.