Select entries using a match string

1. In the left navigation pane, hover on the Data Analysis icon (), then click Report Definitions.
2. On the Report Definitions page, accept the case series shown or click Browse to the right of Case Series to display the Select Case Series page and select a case series.
3. Click a Report Definition's Row Action menu (), then click Edit.
4. On the Edit Report Columns page, next to Data Source, click Select.

   Note:

   If you want to look at all cases, use the report ID (that is, the variable of the Report ID type in the configuration) in the demographics table. It is possible that a report has no record in the other tables. If you are not interested in getting all report IDs, but only those that have records in the table from which you are getting other data, use the report ID from that table.
5. In the Match String field type a string and click Find.

   All entries containing that string are listed; the matching does not distinguish between cases (upper, lower, mixed). See below for tips on how to search for entries using the Match field.

6. To list all entries again, click Show All.

   Note:

   When an entry is highlighted in the list, you can go to the next occurrence of an entry starting with a character that you type. For example, you can highlight the first entry in the list and type “H” to go to the first entry starting with “H”.
7. To highlight an entry, click the entry in the list.
8. You can also do the following:
   • Highlight multiple non-contiguous entries: hold down the Ctrl key while clicking each entry.
   • Highlight multiple contiguous entries: click an entry, hold down the Shift key, and click another entry.
   • Entries between and including those entries are highlighted.
   • Remove highlighting from an entry: hold down the Ctrl key while clicking the selected entry.
9. To move entries back and forth between the list of all entries and the list of selected entries, double-click a highlighted entry or use the arrow keys as follows:

   Button	Use To
   	Move highlighted entries from the list of all entries to the list of selected entries.
   	Move all entries from the list of all entries to the list of selected entries.
   	Move highlighted entries from the list of selected entries to the list of available entries.
   	Move all entries from the list of selected entries to the list of available entries.

   If Clear is available, you can click it to clear out the list of selected entries.

10. If up and down arrows are available for the list of selected entries, you can use them to order the selected entries. For example, when specifying breakdown details in a report definition, you can order the selected entries as you want them to appear in the report.
11. When you are satisfied with the selected entries, click OK. (In some contexts, the button may instead be Save or Copy.)

Special characters

To search for the following special characters, you must precede each special character with a backslash (\):

+

*

?

.

\

(

)

[

]

Example	Description
NAUSEA \+ VOMITING	NAUSEA + VOMITING
\(R\) ELBOW PAIN	(R) ELBOW PAIN

Match string syntax

In the Match String field, you can use the following syntax:

Syntax	What Is Matched	Syntax Example	Found by Example
^	Letter(s) at the beginning of a value.	^V	VERTIGO VOMITING Does not find SEVERE VOMITING.
$	Letter(s) at the end of a value.	on$	AGITATION DEPRESSION Does not find ANEMIA IRON DEFIC.
.	Any single character.	D.stonia	DYSTONIA
[abcdef]	Any character included in the set.	[gq]	All terms that have any of the letters g or q, including: ANGINA FREQUENT URINATION
\b	A word boundary in a term.	\bDr	ABNORMAL DREAMS DRY MOUTH
\s	White space in a term.	en\s	PATHOGEN RESISTANCE SUDDEN INFANT DEATH SYNDROM
\s		\sen	ABDO ENLARGE