Searching for text in a column

Use this procedure to search column for words, letters, numbers, or characters.

About this task

You can perform searches using the (>, <, <=, >=, =) signs to limit the search. You can use a comma to search for multiple items, such as two UPCs (000419392402, 00014124214). In addition, you can use a comma to search for values outside of a specified range, such as items with a volume change > or < 10% (>.10, < -.10). Use quotes to enclose a value that contains a comma, for example, "John, Scenario1".

Searches containing the wildcard character, *, are also allowed. In this example, the following searches can be conducted for the UPC 00012345678910:

  • *78910 will find the UPC that ends in 78910
  • 00012345* will find all UPCs which start in 00012345. This is useful when searching for all items for a manufacturer or vendor.
  • *5678* will find all UPCs which contain 5678

Procedure

  1. Select a column from the Search drop-down menu.
    The column you select is where the search will be performed. You can only search on visible columns.
  2. Enter the word, letter, or character you want to search for.
  3. Click Find.
    The search results will appear. You cannot search again within the results. Only one search can be performed at a time. To clear a search, click Clear Search. The items list will revert back to the pre-search list of items.