How to add your knowledge

Creating Text Expressions

    Table of contents
    No headers

    Version as of 12:55, 18 May 2013

    to this version.

    Return to Version archive.

    View current version

    Text expressions are useful for formatting the results of text-related queries, for example, in tables.

    To create a text expression

    1. Select the command for which you want to create an expression.
    2. In the expression area, do one of the following:
      • Enter a text function manually.
      • Click Text Function and select the function you want.
    3. Click Property. In the Property list, select the property for the function.
    4. Specify any arguments required by the function, enclosed in single quotation marks.

      For example, if you are padding the right side of a text string with two asterisks, the expression looks like this one:

       

      For text expressions, the property is within parentheses, followed by any arguments within single quotation marks.

      If you are translating a text string from mixed case to lowercase, the expression looks like this one:

      Lower (PRODUCT_NAME)

    5. Specify any further conditions for the expression.

      To create a complex property evaluation, insert an AND or OR operator, and then insert another operator, property, and value combination.

      For help with any expression element, see Creating Expressions - Reference.

    6. Click OK to apply the expression.