Substring

To report part of a data element instead of the entire value in the data element, use the substring string function in the Query or Results section.

  1. In Query section, select Request button and then select Query menu (In Results section, select Results menu).
  2. Select Add Computed Item.
  3. Name the new data item in the dialog box.
  4. Press the Functions… button on right in dialog box.
  5. Select String Functions from the Function List Categories window in the Database Functions dialog box.
  6. Select Substr from the Functions available in the window to the right.
  7. Complete the table by referencing the column name, the first character you wish to display and the total number of characters you wish to include in the display of the substring.
  8. Click OK in the Database Functions dialog box.
  9. Click OK in the Item dialog box.
  10. To review/modify the computed item double click on the item name on the Request Line.

Last updated: October 15, 2013

Last updated: October 15, 2013