Field filter operators - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
How Do I
Overview
Tips
Reference
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265

This topic describes operators that you may apply in a field filter. The available operators depend on whether a field is a text, date, or numeric field.

Is equal to
Looks for records that have exactly the value you specify. This can be a numeric value or a text value. For example, you can search for records with a MatchScore value of exactly 82, or records with a LastName value of "Smith."
Is not equal to
Looks for records that have any value other than the one you specify. This can be a numeric value or a text value. For example, you can search for records with any MatchScore value except 100, or records with any LastName except "Smith."
Starts with
Looks for records that start with a particular value in the selected field. For example, if you filter for "Van" in the LastName field you would see records with "Van Buren", Vandenburg", or "Van Dyck".
Contains
Looks for records that contain the value you specify in any position within the selected field. For example, if you filter for "South" in the AddressLine1 field, you would see records with "12 South Ave.", "9889 Southport St.", "600 South Shore Dr.", and "4089 5th St. South".
Does not contain
Looks for records that do not contain the value you specify in any position within the selected field. For example, if you filter for "South" in the AddressLine1 field, you would not see records with "12 South Ave.", "9889 Southport St.", "600 South Shore Dr.", and "4089 5th St. South".
Ends with
Looks for records that end with a particular value in the selected field. For example, if you filter for records that end with "burg" in the City field, you would see records with "Gettysburg", "Fredricksburg", and "Blacksburg".
Is greater than
Looks for records that have a numeric value that is greater than the value you specify.
Is greater than or equal to
Looks for records that have a numeric value that is greater than or equal to the value you specify. For example, if you specify 50, you would see records with a value of 50 or greater in the selected field.
Is less than
Looks for records that have a numeric value that is less than the value you specify.
Is less than or equal to
Looks for records that have a numeric value that is less than or equal to the value you specify. For example, if you specify 50, you would see records with a value of 50 or less in the selected field.
is after
Looks for records that have a date or time value that is later than the value you specify.
Is after or equal to than
Looks for records that have a date or time value that is equal to or later than the value you specify.
Is before
Looks for records that have a date or time value that is earlier than the value you specify.
Is before or equal to than
Looks for records that have a date or time value that is equal to or earlier than the value you specify.