STRIP

STRIP removes all spaces from a given string.

STRIP( <field_name or string> )

  • field name or string: The field or string to be processed

Example: create a field on the Household table that removes all the spaces from the first line of the address.

STRIP([Household.ADDRESS LINE 1])