Using the field filter or advanced filter expression in the attribute table of QGIS, I want to select features that have values in the first three levels and exclude features that values other than zero in levels four and onward.

Using the example data below, I want to select A and B, but not C.

Example Attribute data (letters and brackets and '...' are not in attribute table):

A] 100-000025-000000-000000-000000-000000-000000...

B] 100-000061-136148-000000-000000-000000-000000...

C] 100-023788-278991-424721-236628-000000-000000...

The value is a 144 character string broken into 21 levels. The levels in the code represent the hierarchy of the stream network – a major river would have only Level 1 of the code populated, a stream flowing directly into a major river would have levels 1 and 2 populated, and a stream flowing into this stream would have levels 1, 2 and 3 populated, and so on.

Using the field filter or advanced filter expression in the attribute table of QGIS, I want to select features that have values in the first three levels and exclude features that values other than zero in levels four and onward.

Using the example data below, I want to select A and B, but not C.

Example Attribute data (letters and brackets and '...' are not in attribute table):

A] 100-000025-000000-000000-000000-000000-000000... B] 100-000061-136148-000000-000000-000000-000000... C] 100-023788-278991-424721-236628-000000-000000... 

The value is a 144 character string broken into 21 levels. The levels in the code represent the hierarchy of the stream network – a major river would have only Level 1 of the code populated, a stream flowing directly into a major river would have levels 1 and 2 populated, and a stream flowing into this stream would have levels 1, 2 and 3 populated, and so on.