Data Synchronisation StudioUser GuideCalculated ColumnsFunctionsTRIMOn this pageTRIMRemoves the space character or other specified characters from the start or end of a string.Syntaxstring TRIM(string value)ExampleThe CustomerName field has "'" at either end and you wish to remove this e.g. 'John Smith':TRIM("'","CustomerName)Will return "John Smith".