Skip to main content

Remedy – Remove spaces from string
Remedy – Remove spaces from string

·1 min read
Share

Never trust your users. Here is the tip to remove spaces from string.

Run-If: 'FIELD' LIKE "% "


This remove space before:

Set-Field: zInt = LENGTH($FIELD$) Set-Field: Field = SUBSTR($FIELD$,0,zInt-1)


This remove spaces before and after string:

Set-Field: Field = LTRIM(RTRIM($FIELD$))


This remove all spaces from string:

Set-Field: REPLACE($FIELD$," ","")


L

Lubos Strejcek

Content Writer at STREYDA