Filter rows containing a string of numeric characters of specific length at start of cell

[davidnolan]

Hello,

I would like to filter my data for only rows that contain an 8 digit numeric string at the beginning of the cell. I think RegEx could solve the issue but I'm unsure of how to apply it. Basically I would like to include a filter that brings me from the screenshot 1 below to screenshot 2. Any help would be massively appreciated!

Thanks

Screenshot 1

Screenshot 2

[TurboToad · Accepted solution]

This is one way to filter your results:

REGEX - ^\d{8}.*

^ asserts position at start of a line

\d matches a digit (equivalent to [0-9])

{8} matches the previous token exactly 8 times

. matches any character (except for line terminators)

* matches the previous token between zero and unlimited times, as many times as possible, giving back as needed (greedy)

[binu_acs]

@davidnolan One way of doing this

[nagakavyasri]

Another way:

[davidnolan]

Thank you very much @TurboToad , @binu_acs , and @nagakavyasri  all of these worked and really helped!