Remedy – Remove spaces from string

First rule – Never trust your users. Here is the tip to remove spaces from string. 1. Run-If: ‘FIELD’ LIKE “% ” Set-Field: zInt = LENGTH($FIELD$) Set-Field: Field = SUBSTR($FIELD$,0,zInt-1) 2. Set-Field: Field = LTRIM(RTRIM($FIELD$)) 3. Set-Field: REPLACE($FIELD$,” “,””) In the end, it really depends on you. If you need remove all spaces use 2, in 

Continue Reading…