How to filter zipcodes mixed in 5 and 9 digit formats

building reports webintelligence
1

Hi,

I got a list of zipcodes (over 300) of the area where I need to locate addresses, but some of them are in the 5-digit format and some in the 9-digit format.

I did a query with an inlist condition and on the right side I had the list of all the zipcodes (5 digit format), and it brought me everybody with an address with those exact zipcodes, but I’m missing all the ones with 9-digit format.

Is there a way to mix “Match Pattern” with “InList”? or “InList” using wildcards?

To me it just would be crazy to have 300 MatchPattern conditions, one for each zipcode.

Thank you so much in advance!

Brenda

brendaivett (BOB member since 2014-11-12)

2

The best approach might be to add an additional object in the universe which is just the first 5 characters of the zip code.

You can then use that object in your selection.

mobrien :us: (BOB member since 2004-03-03)

3

You can use =Left([Zip Code];5) to get the first five digits.

4

Thanks for the answers, I could get help to create a field in the universe for only the first 5 digits of the zip codes.

Brenda

brendaivett (BOB member since 2014-11-12)