Navigation: Reference > Transforms >
Tidy whitespace (spaces, tabs, carriage returns etc) in the selected column(s).
•Check the column(s) you wish to transform.
•Check Trim leading and trailing whitespace to remove whitespace characters, such as space and tab.
•Check Replace line feeds with spaces to replace LF (\n) characters with spaces.
•Check Replace tabs with spaces to replace tab (\t) characters with spaces.
•Check Remove carriage returns to remove CR (\r) characters.
•Check Convert consecutive spaces to one space to replace 2 or more consecutive spaces with a single space.
•Check Remove non-printable characters to remove characters of Unicode type Other_*. This include ASCII codes 0 to 31, such as tab, line feed, carriage return, bell and backspace. It does not remove spaces.
•The operations are carried out in top to bottom order, e.g. Replace line feeds with spaces is carried out before Convert consecutive spaces to one space.