Purpose
Remove leading and trailing spaces in an attribute.
Category Location: All, calculate or manipulate
- Attribute to trim : attribute in the input data source to trim
- Write trimmed value to : attribute to house the trimmed data
Tips
Cutting and pasting from one source to another can result in leading or trailing spaces resulting in those spaces being contained in the data source in Openprise. Extra spaces can affect matching results when using the "exact match" method.
Example
- Use trim string to remove leading or trailing spaces in the email field so that you can accurately dedupe people records when matching exactly on the email field.