Point and click interaction for format

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)

Release Notes

None

Attachments

2
  • 14 Jul 2017, 12:41 AM
  • 14 Jul 2017, 12:26 AM

Activity

Show:

Tony Bach July 18, 2017 at 7:03 PM

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Affects versions

Components

Sprint

Fix versions

Priority

Created July 13, 2017 at 6:26 PM
Updated July 24, 2017 at 11:25 PM
Resolved July 24, 2017 at 11:25 PM