EXTRACTNUMBERS() only numbers greater than 99999

I use EXTRACTNUMBERS() to get numbers from a OCRTEXT() column.
This produces a list with numbers like:

1000 , 50 , 5 , 216423 , 3 , 5 , 214517 , 214506 , 214505 , 214516 , 214501 , 214477 , 214515 , 1 , 214504 , 120728 , 217435 , 3 , 214512 , 214507 , 751 , 846 , 951 , 49 , 5 , 8 , 2019

I want to extract only the numbers that have 6 characters like:
AND(>99999 , <1000000)

How can I do that?

0 10 475
10 REPLIES 10
Top Labels in this Space