Skip to Content
Former Member
Sep 16, 2014 at 08:20 PM

Having Issues with "Matches Pattern" and 'Different from Pattern" query operators



I am trying to write a report to look at address formating. I want to look for certain words within the address field so they can be updated to adhere to our business standards.

I'm having a terrible time getting it to work though. I'm using [Address1] Matches Pattern "APT" but, nothing is coming up in the report when I know for fact there are entries in the database where the address contains the string APT.

I have a bunch of these grouped together as part of an or statement.

I am also, for a different field, having issue getting the Different From operator to work. I have a few strings that are ok to have in the field grouped together within an and statement but, it's not pulling to the report correctly either.

Any suggestions on what I may be doing wrong?