Bad-User-Experience

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 case of all spaces then 3.

Leave a Reply