Case

Parent Previous Next


Case Transform


The "Case and Standardization Transform" is a transform that allows the user to format the case of source data using different styles of formatting.



Actions

In the "Choose Action" column, clicking on the <No Action> tag will show the choose action drop down menu.



 Action - by default there no action is selected, without the action selected, no parameters will be present.

o   Convert string to proper case - This action is used to transform the case of source data

  Output Action - The "Case Transform" has the two output options

o  Replace the column data with fixed data

o  Output the fixed data to a new output column - If selected, the new output column name will be "inputcolumn_output". For example, if the source column name is "FirstName", the output column will be "FirstName_output".

 Parameters  Available once the action is selected

o   Style - Select the style table to use, when SimpleProperCase is selected then all other parameters will be ignored.

o   Convert Irish Surnames - Set true or false to indicate whether or not to convert Irish surnames. ex. "OHARA" converts to "O'Hara"

o   Use Typographic Apostrophe - Set this property true or false to indicate whether or not to use the typographic apostrophe in place of the standard apostrophe when converting Irish surnames

o   Correct Common Misspell - Set this property true or false to indicate whether or not to correct common misspellings. ex. "acn" is corrected to "can"

o   Alphanumeric Upper - Set this property true or false to indicate whether or not to convert alphanumeric data to all uppercase.

o   No Vowels Upper - Set this property true or false to indicate whether or not to convert alphabetic data containing no vowels to all uppercase. ex. "mlk" converts to "MLK".

o   Ignore Mixed Case - Set this property true or false to indicate whether or not to convert mixed-case text. Use this setting to preserve existing mixed-case text. Text will only be converted when Text-In string is all uppercase or lowercase.


Please see the Error Row Handling page for more information about this functionality.