Text manipulation steps
-
Trim: trim leading and trailing spaces
-
Substring: extract characters from a specified position in the text
-
Left substring: extract characters from the beginning of the text
-
Right substring: extract characters from the end of the text
-
Pad left: pad value to specified length by adding characters at the beginning
-
Pad right: pad value to specified length by adding characters at the end
-
Normalize whitespaces: replace multiple whitespaces with single space
-
Remove whitespaces: remove all whitespace characters from text
-
Remove accents: remove all accents from characters
-
Lowercase: convert letters in input text to lowercase
-
Propercase: capitalize first letters in input text
-
Uppercase: convert letters in input text to uppercase
-
Remove non-alphanumeric characters: remove non-alphanumeric characters from input text
-
Remove non-ASCII characters: remove non-ASCII characters from input text
-
Remove non-numeric characters: remove non-numeric characters from input text
-
Remove non-printable characters: remove non-printable characters from input text
-
Replace text: replace matches of regular expression within text with another text
-
Calculate formula: use custom formulas to manipulate text