Cleans unwanted spaces from string fields.
Configuration Options
- Fields: Choose one or more fields to transform.
-
Trim whitespace: Choose to trim whitespace from:
- Beginning
- End
- Both Beginning and End
- Remove consecutive whitespaces: Replaces multiple consecutive spaces with a single space.
- Remove all whitespaces: Removes all spaces in the field value.
Examples
| Input Field (Text) | Trim | Remove Consecutive | Remove All | Output |
|---|---|---|---|---|
| Hello World | Both | No | No | Hello World |
| This is a test | No | Yes | No | This is a test |
| Remove every space | No | No | Yes | Removeeveryspace |