<< Click to Display Table of Contents >> Navigation:  Reference > Column types > Text

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.

 

Manipulate columns of text using the Chop, Extract , Insert, Pad, Replace and Substitute transforms.

 

Count the number of times each text value appears in a column using the Count transform.

 

Check text values are as expected in a column using the Verify transform.

 

Generate random text values from a selection using the Random transform.