<< Click to Display Table of Contents >>
Whitespace (such as Space and Tab characters) and case are always significant, unless stated otherwise.
You can remove leading and trailing whitespace by checking trim whitespace in the Input or using the Whitespace transform.
You can change the case using the Case transform.
You can concatenate and split columns of text using the Concat Cols and Split Col transforms.