Use Trim String to remove leading, trailing, or both types of characters from a string field. If no characters are specified, whitespace is trimmed by default.
Steps:
- Select Field to cleanse from the dropdown.
- Enter the specific characters to trim (e.g., “-”, “_”, “M”, “p”).
- Choose a Trim Direction:
- Beginning
- End
- Both – beginning and end
- Enter Maximum to remove which specifies the maximum number of characters that will be removed from the selected direction. If no value is specified, all instances of the specified characters will be removed from the selected direction until the first unspecified character.
- Click Apply.
You can add multiple Trim Characters actions for different fields or use cases.