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)