Advanced Filter

[AECOMC]

Hi,

I'm filtering a set of data, and they all contain a similar identification such as "1A1P01" or "2XDP67", the common denominator in each name is the letter P.

However when I filter "???P??" it comes up with anything containing the letter P not just IDs with the that specific amount of letters.

I hope that makes any sense and you can help me!

Thanks.

 

[PCL]

Re: Advanced Filter Help

Here is the data prepared

Data

1A1P01

2XDP67

22P9999

1A1P03

2XDP66

22P9994

22P9997

22P99990

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

Here is the result with next filter's selection ???P??

Data

1A1P01

2XDP67

1A1P03

2XDP66

Where is the issue ??

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

 

[AECOMC]

Re: Advanced Filter Help

So the date is more like:

Building 1A1P01
Post office 2XDP03
Bridge Pier 2V0P43
Typical Building TYP

I want to filter out those containing "???P??" without out filtering out "Typical Building TYP" because it contains a "P" in the data.

If that makes sense.

 

[Gerald Higgins]

Re: Advanced Filter Help

Ah, the old "additional requirements not mentioned in the OP"

Maybe try this as your filter

" ????P??"

See the difference ? A space character at the beginning ?

Not tested . . . this may not work perfectly, but might get you closer

 

[AECOMC]

Re: Advanced Filter Help

Yes sorry! Thanks for the quick reply!

Unfortunately that didn't make a difference and returns no results.

 

[Gerald Higgins]

Re: Advanced Filter Help

Hmm, strange that it returns no results, I've just tried it on the sample data in post #3 and it shows the first three entries and hides the 4th entry.

Are you choosing the filter option for "Contains" . . . ?

 

[AECOMC]

Re: Advanced Filter Help

After playing around your suggestion has helped! Thanks

I'm now, (using advanced filters) trying to apply multiple criteria. So in addition to * ???P?? *, I now also want to filter out * ???P???? *. My Criteria are below.

Document No	Title
=*sdr*	<>* ???P?? *
=*sdr*	<>* ???P???? *

<colgroup><col><col></colgroup><tbody>
</tbody>

When I run these separately they filter out the data I need, however when ran together they only apply the first line of criteria?

 

[Gerald Higgins]

Re: Advanced Filter Help

Can you give us some examples of data that you think would meet the second criteria, but NOT meet the first criteria ?

For example,
123P4567
would appear to meet both criteria, so I'm not sure why you even need the second criteria.

 

[AECOMC]

Re: Advanced Filter Help

Document No	Title
BCW-BD4-CSVD-LET-001-000433	CHR-005 Change in Pier Shape
M-BD4-000VD0-CSVD-SDR-153031	LINE 1 STRUCTURAL BRIDGES BESPOKE PILE CAP FOR PIER 1Z1P30 PILE CAP REINFORCEMENT LAYOUT
M-BD4-000VD0-CSVD-SDR-700010	LINE 1 & 2 STRUCTURAL PIER FOUNDATION - TYPE TP-F1 PIER HEIGHT H ≤ 11m REINFORCEMENT DETAILS
M-BD4-1G1VD0-CSVD-SDR-140531	VIADUCT STRUCTURES LINE 1 STRUCTURAL BRIDGE 1-8 PIER NO. 1G1PES05 SOUTH PIER DETAILS
M-BD4-2A1VD0-CSVD-SDR-151200	VIADUCT STRUCTURES LINE 2 STRUCTURAL BRIDGE 2-1 CENTRAL PIER NO. 2A1P12 COVER SHEET & DRAWING LIST
M-BD4-2C3VDA-CSVD-SDR-140600	VIADUCT STRUCTURES LINE 2 STRUCTURAL BRIDGE 2-2 PIER NO.2C3PES06 COVER SHEET & DRAWING LIST

<colgroup><col><col></colgroup><tbody>
</tbody>

That is a selection of data from my spreadsheet. The only line of data I want it to return is Line 3, as it has "SDR" in the doc. number and doesn't reference a specific pier.

Note that the pier labels vary in length, and show "NO. " before in some cases etc.

Thanks again for your help.

 

[Gerald Higgins]

Re: Advanced Filter Help

Oh wow these requirements seem to be all over the place !

Is that a pier number in line 1 - "CHR-005" ?