Fixed
Pinned fields
Click on the next to a field label to start pinning.
Details
Details
Assignee
Tony Bach
Tony BachReporter
Joe Farned
Joe FarnedAffects versions
Components
Sprint
None
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
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)