The trimEnd task removes whitespace — including spaces and tabs — from the end of a string.
Use trimEnd to ensure that no trailing spaces remain in string values within a dataset.
In this example, a newVariable task is used to create the input for trimEnd. The variable name is String and its value is Hello World with spaces at both the beginning and end.
The trimEnd task references New Variable: String as the reference task. The reference variable is automatically set to accept the value from that task.
After running the job, the incoming variable in Task History shows spaces before and after Hello World, indicated by the placement of the quotation marks.
The outgoing trimmedEnd value is "Hello World" with the trailing whitespace after World removed.
