How to automatically trim a string to a fixed length without using a string/script function for every field

Document created by janaki_dangeti on May 6, 2015Last modified by Adam Arrowsmith on Sep 20, 2016
Version 3Show Document
  • View in full screen mode

Scenario where the customer is trying to automatically trim a string to fixed length to fit it in the Salesforce fields but where the max length varies from field to field in the source. Using a string/script function to trim each and every field is tedious and makes the mapping harder to read.


Using a Cleanse shape, we can set the Maximum length restriction for each element by trimming the extra characters (either trailing or leading characters).

See User Guide: Cleanse shape