on 09-16-2014 9:20 PM
Hello!
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?
While Running the report you should type the value in this way :
APT%: if you are looking for Cost Centers that begins with "APT"
%APT if you are looking for Cost Centers that ends in "APT"
%APT%: if you are looking for Cost Centers that includes "APT" on any part
Hope this helps
Regards,
Pranay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.