Advanced FilteringAdvanced filtering lets you design complex searches to isolate data to just those values you want. Enter filter strings into the same edit fields you enter filter text. Advanced filtering supports the following operations: White Space To search for white space in a string, enclose the string in double quotes. For example: Nested operators All equations are processed from left to right. Use parenthesis to override these defaults. For example: NOT Search for a string not containing the match data. For example: AND Use the logical AND operator to search for data that must contain multiple values but can appear in different places in the string. For example: OR Use the logical OR operator to search for data that may contain multiple values but must contain at least one. For example: <, <= (Less than or less than or equal to) Returns all data whose value is numerically less than, if a number. If this is alphabetic data then it returns all strings appearing earlier in the alphabet. For example: For example: Note: Dates may also be tested for but must be in the following format: >, >= (Greater than or greater than or equal to) Returns all data whose value is numerically greater than, if a number. If this is alphabetic data then it returns all strings appearing after it in the alphabet. For example: For example: | |||
Topic 254: Send Feedback. Download a PDF of this online book from the first topic in the table of contents. |