Using City and State for Street Name Lookup - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155

To view all street names for a city/state:

  1. In the LastLine field, enter a full city and state.
  2. In the StreetName field, enter "*" (asterisk without quotation marks).
  3. Click Run Preview.
  4. In Preview Output Records on the right side of the pane, note that the results of the search, based on the scope of the input provided, have been placed in the appropriate output fields.

    Example: You enter "Wheaton" and "IL" in the LastLine field. You also enter "*" in the StreetName field. The output records include all street names found for "Wheaton IL".

    Example:You enter "Wheaton" and "IL" in the LastLine field. You also enter "a" in the StreetName field. The output records include all street names that begin with "a" that are found for "Wheaton IL". You can also enter "and" to see all street names that begin with "and" that are found for "Wheaton IL".