Identifying repeating digits

Question

Hi,

I need to clean up phone numbers and I randomly find phone numbers made of the same repeating digit such as "11111111" or "33333333" and the repeating pattern never has the same number of digits, and the digit could go from 1 to 9.

I'd like to check the thousands of rows of the file and to identify all the rows having this pattern.

Do you know how I could do that?

thank you very much

philipmannering · Accepted Answer

Regex Tool > Match with expression

(\d)\1*

will be true for numbers (of any length) that are all the same digit.

Esmeralda_In_Paris · Accepted Answer

hi @PhilipMannering

thank you so much! It works perfectly