Name Formatting

To return a string up to 80 characters for a formatted name (different modes allow for different return formats), use the Name Format data function in the Query section.

  1. In Query section, select Query menu, select Add Computed Item and name the new data item in the dialog box.
  2. In the panel, type Namefmt followed by a left paren.
  3. Next, type the Mode letter in single quotes, followed by a comma.

    Possible Modes are:
    A Smith, J.
    B Smith Jr., Dr. John Robert
    C Dr. John Robert Smith,Jr. (for Commencement Program. Same as type R except for “,” Jr and Sr suffixes.)
    D Smith Jr., Dr. John R
    F John Smith
    G John Smith Jr.
    H Dr. John Smith Jr.
    I J. Smith
    J J. Smith Jr.
    L Smith
    M John R. Smith
    N John R. Smith Jr.
    R Dr. John Robert Smith Jr.
    S Smith Jr
    X John
    Y Robert

  4. Use the Reference button to select the Name data element from the table and type a comma.
    • If the Prefix and Suffix data elements are not available in the table:
      1. Type a set of single quotes, followed by a comma.
      2. Type a second set of single quotes, followed by a right paren.

Namefmt(‘M’,’Table.Name’,”,”)

    • If the Prefix and Suffix data elements are available in the table:
      1. Use the Reference button to select the Prefix data element from the table and type a comma.
      2. Use the Reference button to select the Suffix data element from the table and type a right paren.

Namefmt(‘R’,’Table.Name’,’Table.Prefix’,’Table.Suffix’)

  1. Click OK in the Item dialog box.
  2. 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