Search using wildcard characters

A wildcard character is a keyboard character , such as * or ?, that represents one or more characters when searching for values in the data grid.

Use wildcard characters when the exact value you want to search for is unknown, but you know part of the name or pattern. For example, enter John*, if you want to find a user whose name begins with John, but you do not know the full name. The search returns all results that start with John.

Wildcard search patterns that are supported are as follows:

• Starts with: Find records that start with specific characters. For example, enter A* to retrieve records that start with A.

• Ends with: Find records that end with specific characters. For example, enter *A to retrieve records that end with A.

• Start, end, and with characters in between: Find records with a known pattern across the start, middle, and end. For example, enter A*0*Z to retrieve records that start with A, include 0 somewhere in between, and end with Z.

• Start and end with exact length. Find records of a specific length with known values for the start and the end. For example, enter A*?????*Z to retrieve records that start with A, end with Z, and have exactly 5 characters in between.