Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2.0
    • Fix Version/s: 4.2.1
    • Component/s: UI
    • Labels:
      None
    • Sprint:
      UP6 Sprint 1
    • Rank:
      1|i004zz:

      Description

      As a user, I want to be able to format rows which data type is string.
      These directives can be applied to specific data type. If the data type doesn't match the directive is disabled.
      If the system is unable to recognize the type of data, the directives are enabled.

      Operation Data Type Description Requires user input Expression
      Date and Time Date N/A No Use Existing
      UPPERCASE String UPPERCASE converts all characters in the String to uppercase No Use Existing
      Lowercase String Uppercase converts all characters in the String to lowercase No Use Existing
      TtitleCase String TitleCase capitalizes the first character of each word in the String No Use Existing
      Concatenate String Concatenate joins together two strings (one in the column and one user provided) Yes <column> + <user_provided_text>
      Trim Whitespace String Trim returns at String with leading and trailing spaces removed No Use Data Prep directive: trim <column>
      Trim Leading Whitespace String Trim returns at String with leading spaces removed No Use Data Prep directive: ltrim <column>
      Trim Trailing Whitespace String Trim returns at String with trailing spaces removed No Use Data Prep directive: rtrim <column>

      Concatenate third tier input box has the following:

      • Text input box (hint text: Enter string)
      • Drop-down menu (choices: at the beginning (default); at the end)
      • Check box to allow the user to "Create new column" where place the results (default: the original column is affected by the directive)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tbach Tony Bach
                Reporter:
                joe.farned Joe Farned
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: